{"provider_name":"Hatena Blog","image_url":null,"author_name":"devillikeaangel","version":"1.0","width":"100%","title":"Postgres \u30b3\u30de\u30f3\u30c9","url":"https://kkkw.hatenablog.jp/entry/20080403/1207208322","blog_title":"kikukawa's diary","blog_url":"https://kkkw.hatenablog.jp/","published":"2008-04-03 16:38:42","type":"rich","categories":["Postgres"],"height":"190","description":"Linux\u4e0a\u3067 DB\u4e00\u89a7\u3092\u8868\u793a psql -U postgres -l\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u304b\u3089 \u30c6\u30fc\u30d6\u30eb\u3092csv\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u51fa\u529b \\pset format unaligned \\pset fieldsep ',' \\o /tmp/out.csv select * from t_hoge where fugafuga\u30af\u30a8\u30ea\u767a\u884c\u5c65\u6b74\u8868\u793a \\s\u30c6\u30fc\u30d6\u30eb\u306e\u4e00\u89a7\u8868\u793a \\dt_hoge\u30c6\u30fc\u30d6\u30eb\u306e\u60c5\u5831\u8868\u793a \\d t_hoge DB\u306e\u4e00\u89a7\u8868\u793a \\l /tmp/test.sql \u3092\u8aad\u307f\u8fbc\u3093\u3067\u5b9f\u884c \\i /tmp/test.sql psql\u30aa\u30d7\u30b7\u30e7\u30f3 \\pset null hogehoge NULL\u3092 hogehoge\u2026","author_url":"https://blog.hatena.ne.jp/devillikeaangel/","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkkkw.hatenablog.jp%2Fentry%2F20080403%2F1207208322\" title=\"Postgres \u30b3\u30de\u30f3\u30c9 - kikukawa&#39;s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}