\u25a0 postgres \u30e6\u30fc\u30b6\u3067\u30ed\u30b0\u30a4\u30f3
\n[bash]
\n> psql -U postgres
\n\u30e6\u30fc\u30b6\u30fc postgres \u306e\u30d1\u30b9\u30ef\u30fc\u30c9:
\npsql (10.4)
\n"help" \u3067\u30d8\u30eb\u30d7\u3092\u8868\u793a\u3057\u307e\u3059\u3002
\n[\/bash]<\/p>\n
\u25a0 PostgreSQL\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d
\n[bash]
\npostgres=# select version();
\n version
\n————————————————————
\n PostgreSQL 10.4, compiled by Visual C++ build 1800, 64-bit
\n(1 \u884c)<\/p>\n
[\/bash]<\/p>\n
\u25a0 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u8868\u793a
\n[bash]
\npostgres=# \\l
\n \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7
\n \u540d\u524d | \u6240\u6709\u8005 | \u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0 | \u7167\u5408\u9806\u5e8f | Ctype(\u5909\u63db\u6f14\u7b97\u5b50) | \u30a2\u30af\u30bb\u30b9\u6a29\u9650
\n———–+———-+——————+——————–+——————–+———————–
\n postgres | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 |
\n template0 | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 | =c\/postgres +
\n | | | | | postgres=CTc\/postgres
\n template1 | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 | =c\/postgres +
\n | | | | | postgres=CTc\/postgres
\n(3 \u884c)
\n[\/bash]<\/p>\n
\u25a0 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210
\n[bash]
\npostgres=# create database sample_db;
\nCREATE DATABASE
\n[\/bash]<\/p>\n
\u25a0 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7\u8868\u793a
\n[bash]
\npostgres=# \\l
\n \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7
\n \u540d\u524d | \u6240\u6709\u8005 | \u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0 | \u7167\u5408\u9806\u5e8f | Ctype(\u5909\u63db\u6f14\u7b97\u5b50) | \u30a2\u30af\u30bb\u30b9\u6a29\u9650
\n———–+———-+——————+——————–+——————–+———————–
\n postgres | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 |
\n sample_db | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 |
\n template0 | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 | =c\/postgres +
\n | | | | | postgres=CTc\/postgres
\n template1 | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 | =c\/postgres +
\n | | | | | postgres=CTc\/postgres
\n(4 \u884c)
\n[\/bash]<\/p>\n
\u25a0 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u524a\u9664
\n[bash]
\npostgres=# drop database sample_db;
\nDROP DATABASE
\npostgres=# \\l
\n \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4e00\u89a7
\n \u540d\u524d | \u6240\u6709\u8005 | \u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0 | \u7167\u5408\u9806\u5e8f | Ctype(\u5909\u63db\u6f14\u7b97\u5b50) | \u30a2\u30af\u30bb\u30b9\u6a29\u9650
\n———–+———-+——————+——————–+——————–+———————–
\n postgres | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 |
\n template0 | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 | =c\/postgres +
\n | | | | | postgres=CTc\/postgres
\n template1 | postgres | UTF8 | Japanese_Japan.932 | Japanese_Japan.932 | =c\/postgres +
\n | | | | | postgres=CTc\/postgres
\n(3 \u884c)
\n[\/bash]<\/p>\n
\u25a0 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210 with \u30e6\u30fc\u30b6
\n[bash]
\npostgres=# create database sample_db owner sample;
\nERROR: \u30ed\u30fc\u30eb"sample"\u306f\u5b58\u5728\u3057\u307e\u305b\u3093
\npostgres=# create user sample;
\nCREATE ROLE
\npostgres=# create database sample_db owner sample;
\nCREATE DATABASE
\npostgres=# alter role sample with password ‘password’;
\nALTER ROLE
\npostgres=# alter role sample with createdb;
\nALTER ROLE
\n[\/bash]<\/p>\n","protected":false},"excerpt":{"rendered":"
\u25a0 postgres \u30e6\u30fc\u30b6\u3067\u30ed\u30b0\u30a4\u30f3 [bash] > psql -U postgres \u30e6\u30fc\u30b6\u30fc postgres \u306e\u30d1\u30b9\u30ef\u30fc\u30c9: psql (10.4) "help" \u3067\u30d8\u30eb\u30d7\u3092\u8868\u793a\u3057\u307e\u3059\u3002 [ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[65,4],"tags":[],"class_list":["post-2625","post","type-post","status-publish","format-standard","hentry","category-postgresql","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2625"}],"version-history":[{"count":5,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2625\/revisions"}],"predecessor-version":[{"id":2630,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/2625\/revisions\/2630"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}