{"id":3784,"date":"2015-06-14T16:08:16","date_gmt":"2015-06-14T16:08:16","guid":{"rendered":"http:\/\/blog.bachi.net\/?p=3784"},"modified":"2015-06-14T16:31:18","modified_gmt":"2015-06-14T16:31:18","slug":"postgresql","status":"publish","type":"post","link":"https:\/\/blog.bachi.net\/?p=3784","title":{"rendered":"PostgreSQL"},"content":{"rendered":"<h3>Show databases<\/h3>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ psql -l\r\nor\r\n$ psql MyDB\r\nMyDB-# \\l\r\n\r\n                         List of databases\r\n   Name    | Owner | Encoding | Collate | Ctype | Access privileges\r\n-----------+-------+----------+---------+-------+-------------------\r\n openerp   | pgsql | UTF8     | C       | C     |\r\n postgres  | pgsql | UTF8     | C       | C     |\r\n template0 | pgsql | UTF8     | C       | C     | =c\/pgsql         +\r\n           |       |          |         |       | pgsql=CTc\/pgsql\r\n template1 | pgsql | UTF8     | C       | C     | =c\/pgsql         +\r\n           |       |          |         |       | pgsql=CTc\/pgsql\r\n(4 rows)\r\n<\/pre>\n<h3>Show roles\/user<\/h3>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nMyDB-# \\du\r\n                             List of roles\r\n Role name |                   Attributes                   | Member of\r\n-----------+------------------------------------------------+-----------\r\n openerp   |                                                | {}\r\n pgsql     | Superuser, Create role, Create DB, Replication | {}\r\n<\/pre>\n<h3>Change role\/user<\/h3>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nMyDB-# alter role openerp CREATEDB;\r\nALTER ROLE\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Show databases $ psql -l or $ psql MyDB MyDB-# \\l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges &#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;-+&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- openerp | pgsql | UTF8 | C | C | postgres | pgsql | UTF8 | C | C | template0 | pgsql | UTF8 | C | [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3784","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/3784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3784"}],"version-history":[{"count":3,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/3784\/revisions"}],"predecessor-version":[{"id":3787,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/3784\/revisions\/3787"}],"wp:attachment":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}