{"id":1173,"date":"2012-07-03T11:38:21","date_gmt":"2012-07-03T02:38:21","guid":{"rendered":"http:\/\/www23.atpages.jp\/~inoni\/?p=1173"},"modified":"2012-07-03T11:38:21","modified_gmt":"2012-07-03T02:38:21","slug":"postgresql%e8%a6%9a%e6%9b%b8-psql%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6sql%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%82%92%e5%ae%9f%e8%a1%8c","status":"publish","type":"post","link":"http:\/\/anada.cloudfree.jp\/?p=1173","title":{"rendered":"PostgreSQL\u899a\u66f8 PSQL\u3092\u4f7f\u3063\u3066SQL\u30d5\u30a1\u30a4\u30eb\u3092\u5b9f\u884c"},"content":{"rendered":"

\u666e\u6bb5\u306fpgAmin\u3092\u4f7f\u3063\u3066SQL\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u306e\u3060\u3051\u3069\u3001SQL\u30d5\u30a1\u30a4\u30eb\u304c\u30c7\u30ab\u3059\u304e\u3066\u3001\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3051\u306a\u3044\u5834\u5408\u306f\u3001PSQL\u3092\u3064\u304b\u3046\u304b\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u3092\u5206\u6563\u3057\u3066SQL\u3092\u6d41\u3057\u3066\u3044\u304f\u3057\u304b\u306a\u3044\u3002<\/p>\n

\u3068\u3044\u3046\u3053\u3068\u3067\u3001PSQL\u3092\u4f7f\u3063\u305fSQL\u30d5\u30a1\u30a4\u30eb\u5b9f\u884c\u3002<\/p>\n

\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u958b\u3044\u3066\u3001cd\u7b49\u3067postgreSQL\u306epsql.exe\u306e\u3042\u308b\u30d5\u30a9\u30eb\u30c0\uff08bin)\u307e\u3067\u9077\u79fb\u3057\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c<\/p>\n

psql -U yyy -h localhost xxx<\/strong>
\n\u30e6\u30fc\u30b6 yyy\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\uff1a\uff08\u3053\u3053\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066Enter\uff09<\/strong><\/p>\n

xxx => \uffe5i dump.sql<\/strong><\/p>\n

\uff08xxx\uff1aDB\u540d\u3001yyy\uff1a\u30e6\u30fc\u30b6ID\u3001dump.sql\uff1aSQL\u30d5\u30a1\u30a4\u30eb\u540d\uff09<\/p>\n

DB\u304c\u30ed\u30fc\u30ab\u30eb\u306b\u306a\u3044\u5834\u5408\u306f\u3001localhost\u306e\u7b87\u6240\u3092DB\u30b5\u30fc\u30d0\u30fc\u306eIP\u30a2\u30c9\u30ec\u30b9\u306b\u5909\u3048\u308c\u3070\u3088\u3044\u3002<\/p>\n

\u3053\u306e\u4f8b\u306e\u5834\u5408\u306fdump.sql\u3092psql.exe\u3068\u540c\u3058\u30d5\u30a9\u30eb\u30c0\u306b\u5165\u308c\u3066\u3044\u308b\u3002<\/p>\n

\u7d42\u4e86\u3059\u308b\u3068\u304d\u306f\u3001<\/p>\n

xxx => \uffe5q<\/strong><\/p>\n

\u3067psql\u3092\u7d42\u4e86\u3059\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u666e\u6bb5\u306fpgAmin\u3092\u4f7f\u3063\u3066SQL\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u306e\u3060\u3051\u3069\u3001SQL\u30d5\u30a1\u30a4\u30eb\u304c\u30c7\u30ab\u3059\u304e\u3066\u3001\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3051\u306a\u3044\u5834\u5408\u306f\u3001PSQL\u3092\u3064\u304b\u3046\u304b\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u8eab\u3092\u5206\u6563\u3057\u3066SQL\u3092\u6d41\u3057\u3066\u3044\u304f\u3057\u304b\u306a\u3044\u3002 \u3068\u3044\u3046\u3053\u3068\u3067\u3001PSQL\u3092\u4f7f\u3063\u305fSQL […]<\/p>\n","protected":false},"author":1,"featured_media":528,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-1173","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql"],"_links":{"self":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts\/1173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1173"}],"version-history":[{"count":0,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts\/1173\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/media\/528"}],"wp:attachment":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1173"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}