{"provider_name":"Hatena Blog","categories":["\u6280\u8853\u30e1\u30e2"],"width":"100%","provider_url":"https://hatena.blog","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdekuo-03.hatenablog.jp%2Fentry%2F2020%2F01%2F21%2F000000\" title=\"PostgreSQL\u30af\u30a8\u30ea\u30b3\u30de\u30f3\u30c9\u899a\u66f8 - \u5de5\u4f5c\u3068\u7af6\u99ac2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","url":"https://dekuo-03.hatenablog.jp/entry/2020/01/21/000000","title":"PostgreSQL\u30af\u30a8\u30ea\u30b3\u30de\u30f3\u30c9\u899a\u66f8","author_name":"dekuo-03","version":"1.0","published":"2020-01-21 00:00:00","blog_url":"https://dekuo-03.hatenablog.jp/","author_url":"https://blog.hatena.ne.jp/dekuo-03/","blog_title":"\u5de5\u4f5c\u3068\u7af6\u99ac2","description":"\u30b3\u30e1\u30f3\u30c8 -- \u30cf\u30a4\u30d5\u30f3\u30922\u3064 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7 select * from pg_database; \u30c6\u30fc\u30d6\u30eb\u540d\u4e00\u89a7 select relname as TABLE_NAME from pg_stat_user_tables; \u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30ab\u30e9\u30e0\u4e00\u89a7 select * from information_schema.columns where table_catalog='\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d' and table_name='\u30c6\u30fc\u30d6\u30eb\u540d' order by ordinal_position; \u30ec\u30b3\u30fc\u30c9\u3092\u30af\u30a8\u30ea select \u30ab\u30e9\u30e0\u540d, ... from \u30c6\u30fc\u30d6\u30eb\u540d \u6761\u4ef6 where \u30ab\u30e9\u30e0\u540d \u6bd4\u2026","type":"rich"}