{"id":218,"date":"2014-07-10T10:56:16","date_gmt":"2014-07-10T01:56:16","guid":{"rendered":"http:\/\/kei0310.info\/?p=218"},"modified":"2014-07-10T10:56:16","modified_gmt":"2014-07-10T01:56:16","slug":"postgresql-%e3%82%88%e3%81%8f%e4%bd%bf%e3%81%86%e5%9f%ba%e6%9c%ac%e3%82%b3%e3%83%9e%e3%83%b3%e3%83%89","status":"publish","type":"post","link":"http:\/\/kei0310.info\/?p=218","title":{"rendered":"[PostgreSQL] \u3088\u304f\u4f7f\u3046\u57fa\u672c\u30b3\u30de\u30f3\u30c9"},"content":{"rendered":"<p>PostgreSQL\u3067psql\u306e\u30b3\u30de\u30f3\u30c9\u5165\u529b\u3092\u3059\u308b\u5834\u5408\u306e\u4e00\u822c\u7684SQL\u4ee5\u5916\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5217\u6319\u3057\u307e\u3059\u3002<\/p>\n<p>\u25cf\\d<br \/>\n\u30c6\u30fc\u30d6\u30eb\u3001\u30b7\u30fc\u30b1\u30f3\u30b9\u306e\u4e00\u89a7\u3092\u5217\u6319\u3057\u307e\u3059\u3002<\/p>\n<p>\uff08\u4f8b\uff09<\/p>\n<pre>\r\n<tt>\r\npostgres=# \\d\r\n                      \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u4e00\u89a7\r\n \u30b9\u30ad\u30fc\u30de |            \u540d\u524d             |    \u578b    |  \u6240\u6709\u8005\r\n----------+-----------------------------+----------+----------\r\n public   | import_test_tbl             | \u30c6\u30fc\u30d6\u30eb | postgres\r\n public   | \u5c65\u6b74\u30c6\u30fc\u30d6\u30eb                | \u30c6\u30fc\u30d6\u30eb | postgres\r\n(2 \u884c)\r\n<\/tt>\r\n<\/pre>\n<p>\u25cf\\d [\u30c6\u30fc\u30d6\u30eb\u540d]<br \/>\n\u6307\u5b9a\u30c6\u30fc\u30d6\u30eb\u306e\u9805\u76ee\u3092\u5217\u6319\u3057\u307e\u3059\u3002<\/p>\n<p>\uff08\u4f8b\uff09<\/p>\n<pre>\r\n<tt>\r\npostgres=# \\d \u5c65\u6b74\u30c6\u30fc\u30d6\u30eb\r\n          \u30c6\u30fc\u30d6\u30eb \"public.\u5c65\u6b74\u30c6\u30fc\u30d6\u30eb\"\r\n    \u5217     |             \u578b              | \u4fee\u98fe\u8a9e\r\n-----------+-----------------------------+--------\r\n date_time | timestamp without time zone |\r\n id        | integer                     |\r\n val       | integer                     |\r\n<\/tt>\r\n<\/pre>\n<p>\u25cf\\di<br \/>\nindex\u306e\u4e00\u89a7\u3092\u5217\u6319\u3057\u307e\u3059\u3002<\/p>\n<p>\uff08\u4f8b\uff09<\/p>\n<pre>\r\n<tt>\r\npostgres=# \\di\r\n                                         \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u4e00\u89a7\r\n \u30b9\u30ad\u30fc\u30de |               \u540d\u524d               |      \u578b      |  \u6240\u6709\u8005  |          \u30c6\u30fc\u30d6\u30eb\r\n----------+----------------------------------+--------------+----------+-----------------------------\r\n public   | import_test_tbl_pkey             | \u30a4\u30f3\u30c7\u30c3\u30af\u30b9 | postgres | import_test_tbl\r\n(1 \u884c)\r\n<\/tt>\r\n<\/pre>\n<p>\u30ef\u30a4\u30eb\u30c9\u30ab\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u3001index\u306e\u540d\u79f0\u306e\u4e00\u90e8\u3067\u691c\u7d22\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<br \/>\n\uff08\u4f8b\uff09<\/p>\n<pre>\r\n<tt>\r\npostgres=# \\di import_test*\r\n                                         \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u4e00\u89a7\r\n \u30b9\u30ad\u30fc\u30de |               \u540d\u524d               |      \u578b      |  \u6240\u6709\u8005  |          \u30c6\u30fc\u30d6\u30eb\r\n----------+----------------------------------+--------------+----------+-----------------------------\r\n public   | import_test_tbl_pkey             | \u30a4\u30f3\u30c7\u30c3\u30af\u30b9 | postgres | import_test_tbl\r\n(1 \u884c)\r\n<\/tt>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL\u3067psql\u306e\u30b3\u30de\u30f3\u30c9\u5165\u529b\u3092\u3059\u308b\u5834\u5408\u306e\u4e00\u822c\u7684SQL\u4ee5\u5916\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5217\u6319\u3057\u307e\u3059\u3002 \u25cf\\d \u30c6\u30fc\u30d6\u30eb\u3001\u30b7\u30fc\u30b1\u30f3\u30b9\u306e\u4e00\u89a7\u3092\u5217\u6319\u3057\u307e\u3059\u3002 \uff08\u4f8b\uff09 postgres=# \\d \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u306e\u4e00\u89a7 \u30b9\u30ad\u30fc\u30de | \u540d [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37,10],"tags":[69,38,67,68],"_links":{"self":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/218"}],"collection":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=218"}],"version-history":[{"count":1,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":219,"href":"http:\/\/kei0310.info\/index.php?rest_route=\/wp\/v2\/posts\/218\/revisions\/219"}],"wp:attachment":[{"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kei0310.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}