{"id":75,"date":"2019-04-04T22:12:01","date_gmt":"2019-04-04T22:12:01","guid":{"rendered":"http:\/\/www.sqlgeometry.com\/?p=75"},"modified":"2019-04-04T22:12:01","modified_gmt":"2019-04-04T22:12:01","slug":"pgadmin-4-tips","status":"publish","type":"post","link":"https:\/\/www.sqlgeometry.com\/?p=75","title":{"rendered":"pgAdmin 4 Tips"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">pgAdmin 4 has a few useful things I should remember:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> <strong>Query History <\/strong>is really neat. Second tab in the Query Editor page, shows a history of all the queries  made and the outcome messages. Easy to find what you have already done.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Ctrl Space<\/strong> triggers code completion. Not quite as good as an IDE but helpful none the less<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Keep you columns lower case<\/strong> and you  wont have to use quotes for your tables in table queries.<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>pgAdmin 4 has a few useful things I should remember: Query History is really neat. Second tab in the Query Editor page, shows a history of all the queries made and the outcome messages. Easy to find what you have already done. Ctrl Space triggers code completion. Not quite as good as an IDE but &hellip; <a href=\"https:\/\/www.sqlgeometry.com\/?p=75\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">pgAdmin 4 Tips<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/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-75","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=\/wp\/v2\/posts\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=75"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":76,"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=\/wp\/v2\/posts\/75\/revisions\/76"}],"wp:attachment":[{"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlgeometry.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}