{"id":595,"date":"2018-06-21T09:31:04","date_gmt":"2018-06-21T09:31:04","guid":{"rendered":"http:\/\/ijbd.eu\/?page_id=595"},"modified":"2018-06-21T10:05:56","modified_gmt":"2018-06-21T10:05:56","slug":"postgresql-cheat-sheet","status":"publish","type":"page","link":"https:\/\/ijbd.eu\/?page_id=595","title":{"rendered":"PostgreSQL cheat sheet"},"content":{"rendered":"<p>PostgreSQL <a href=\"https:\/\/www.postgresql.org\/docs\/current\/static\/app-psql.html\">psql<\/a>.<\/p>\n<ul>\n<li><strong>psql -h hostname\u00a0 dbname username<\/strong> :connect to a database as user<\/li>\n<li>\\list or <strong>\\l<\/strong> :list all databases<\/li>\n<li><strong>\\dt<\/strong> :list all tables in the current database<\/li>\n<li>drop table &lt;schema&gt;.&lt;table&gt;; :delete table<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL psql. psql -h hostname\u00a0 dbname username :connect to a database as user \\list or \\l :list all databases \\dt :list all tables in the current database drop table &lt;schema&gt;.&lt;table&gt;; :delete table &nbsp; &nbsp;<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":79,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-595","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/P4qwq1-9B","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ijbd.eu\/index.php?rest_route=\/wp\/v2\/pages\/595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ijbd.eu\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ijbd.eu\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ijbd.eu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ijbd.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=595"}],"version-history":[{"count":5,"href":"https:\/\/ijbd.eu\/index.php?rest_route=\/wp\/v2\/pages\/595\/revisions"}],"predecessor-version":[{"id":601,"href":"https:\/\/ijbd.eu\/index.php?rest_route=\/wp\/v2\/pages\/595\/revisions\/601"}],"up":[{"embeddable":true,"href":"https:\/\/ijbd.eu\/index.php?rest_route=\/wp\/v2\/pages\/79"}],"wp:attachment":[{"href":"https:\/\/ijbd.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}