{"id":8452,"date":"2014-07-15T05:06:35","date_gmt":"2014-07-14T19:06:35","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=8452"},"modified":"2014-07-15T05:06:35","modified_gmt":"2014-07-14T19:06:35","slug":"postgresql-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/postgresql-primer-tutorial\/","title":{"rendered":"PostgreSQL Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/PostgreSQL\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"PostgreSQL Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Mac\/PostgreSQL\/PostgreSQL_Primer-13of.jpg\" title=\"PostgreSQL Primer Tutorial\"  \/><\/a><p class=\"wp-caption-text\">PostgreSQL Primer Tutorial<\/p><\/div>\n<p>Welcome to the PostgreSQL (Database Server) Primer Tutorial.<\/p>\n<p>The PostgreSQL Database Server product is an excellent Open Source database that has been established for many years.  PostgreSQL is an object-relational database management system, and read along with <a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/PostgreSQL' title='PostgreSQL information from Wikipedia ... thanks.'>Wikipedia<\/a>, how its emphases are extensibility and standards-compliance.<\/p>\n<p>Doing this tutorial, and please forgive my naivety with PostgreSQL, I was amazed at the <a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/Data_definition_language' title='DDL information from Wikipedia ... thanks'>DDL<\/a> similarities with those databases I was more familiar with, namely MySql, MS-SQL, Oracle, Advantage and Access, and can imagine setting up workable systems in a short space of time.<\/p>\n<p>In the primer <a target=_blank title='click picture' href='http:\/\/www.rjmprogramming.com.au\/Mac\/PostgreSQL\/'>tutorial<\/a> you can see early parts of an install to a MacBook Pro and its &#8220;psql&#8221; command line interface, like the wonderful &#8220;sqlplus&#8221; interface of Oracle.<\/p>\n<p>Link to PostgreSQL Database Server more information &#8230; <a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/PostgreSQL' title='Link to PostgreSQL Database Server more information'>via Wikipedia<\/a>.<br \/>\nLink to PostgreSQL Database Server home &#8230; <a target=_blank href='http:\/\/www.postgresql.org' title='PostgreSQL'>Open Source<\/a>.<br \/>\nLink to PostgreSQL Database Server &#8230; <a target=_blank href='http:\/\/www.postgresql.org\/docs\/' title='PostgreSQL documentation'>documentation<\/a>.<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d8452' onclick='var dv=document.getElementById(\"d8452\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?cat=47\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d8452' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to the PostgreSQL (Database Server) Primer Tutorial. The PostgreSQL Database Server product is an excellent Open Source database that has been established for many years. PostgreSQL is an object-relational database management system, and read along with Wikipedia, how its &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/postgresql-primer-tutorial\/\">Continue reading <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":[9,12,37],"tags":[299,304,877,971,1005,1186,1319],"class_list":["post-8452","post","type-post","status-publish","format-standard","hentry","category-database","category-elearning","category-tutorials","tag-database-2","tag-ddl","tag-open-source","tag-postgresql","tag-psql","tag-sql","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/8452"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=8452"}],"version-history":[{"count":0,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/8452\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=8452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=8452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=8452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}