{"id":1650,"date":"2018-08-14T08:43:39","date_gmt":"2018-08-14T08:43:39","guid":{"rendered":"http:\/\/dbtut.com\/?p=1650"},"modified":"2018-11-09T22:59:52","modified_gmt":"2018-11-09T22:59:52","slug":"postgresql-basics","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/","title":{"rendered":"PostgreSQL Basics"},"content":{"rendered":"

Overview<\/strong><\/span><\/span><\/p>\n

PostgreSQL, often simply Postgres, is\u00a0an object-relational database management\u00a0system (ORDBMS) with an emphasis on\u00a0extensibility and standards compliance. As a\u00a0database server, its primary functions are to\u00a0store data securely and return that data in\u00a0response to requests from other software\u00a0applications. It can handle workloads ranging\u00a0from small single-machine applications to\u00a0large Internet-facing applications (or for data\u00a0warehousing) with many concurrent users;
\non macOS Server, PostgreSQL is the default\u00a0database; and it is also available for Microsoft\u00a0Windows and Linux (supplied in most\u00a0distributions).
\nPostgreSQL is ACID-compliant\u00a0and transactional. PostgreSQL has\u00a0updatable views and materialized\u00a0views, triggers, foreign keys; supports
\nfunctions and stored procedures, and other\u00a0expandability.\u00a0PostgreSQL is developed by the PostgreSQL\u00a0Global Development Group, a diverse group
\nof many companies and individual\u00a0contributors. It is free and open-source, released under the terms of the PostgreSQL\u00a0License, a permissive software license.<\/p>\n

Advantages of Using Postgres<\/span><\/strong><\/p>\n

1. Open Source DBMS<\/strong><\/h5>\n
\n
\n

Only PostgreSQL provides enterprise-class performance and functions among current Open Source DBMS with no end of development possibilities. Also, PostgreSQL users can directly participate in the community and post and share inconveniences and bugs.<\/p>\n

2. Diverse Community
\n<\/strong><\/p>\n

One of the characteristics of PostgreSQL is that there are a wide variety of communities. Regarding PostgreSQL as Open Source DBMS, users themselves can develop modules and propose the module to the community. The development possibility is superior high with collecting opinions from its own global community organized with all different kinds of people. Collective Intelligence, as some might call it, facilitates transmission of indigenous knowledge greatly within the communities.<\/p>\n<\/div>\n<\/div>\n

\n
\n

3. Function
\n<\/strong><\/p>\n

SQL functions called \u2018Store Procedure\u2019 can be used for server environment. Also, we support languages similar to PL\/SQL in Oralcle such as PL\/pgSQL, PL\/Python, PL\/Perl, C\/C++, and PL\/R.<\/p>\n<\/div>\n<\/div>\n

\n
\n

4. ACID and Transaction
\n<\/strong><\/p>\n

PostgreSQL support ACID(Atomicity, Consistency, Isolation, Durability).<\/p>\n<\/div>\n<\/div>\n

\n
\n

5. Diverse indexing techniques
\n<\/strong><\/p>\n

PostgreSQL not only provides B+ tree index techniques, but various kinds of techniques such as GIN(Generalized Inverted Index), and GiST(Generalized Search Tree), etc as well.<\/p>\n<\/div>\n<\/div>\n

\n
\n

6. Flexible Full-text search
\n<\/strong><\/p>\n

Full-text search is available when searching for strings with execution of vector operation and string search.<\/p>\n

\n
\n

7. Diverse kinds of replication
\n<\/strong><\/p>\n

PostgreSQL supports a variety of replication methods such as Streaming Replication , Slony-I, and cascading.<\/p>\n<\/div>\n<\/div>\n

\n
\n

8. Diversified extension functions
\n<\/strong><\/p>\n

PostgreSQL supports different kinds of techniques for geographic data storage such as PostGIS, Key-Value Store, and DBLink.<\/p>\n<\/div>\n

9.\u00a0 Cross Platform<\/strong><\/p>\n

It also is available for almost every operating system with the latest stable release.<\/p>\n<\/div>\n<\/div>\n<\/div>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

Overview PostgreSQL, often simply Postgres, is\u00a0an object-relational database management\u00a0system (ORDBMS) with an emphasis on\u00a0extensibility and standards compliance. As a\u00a0database server, its primary functions are to\u00a0store data securely and return that data in\u00a0response to requests from other software\u00a0applications. It can handle workloads ranging\u00a0from small single-machine applications to\u00a0large Internet-facing applications (or for data\u00a0warehousing) with many concurrent users; …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":109,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1650","post","type-post","status-publish","format-standard","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nPostgreSQL Basics - Database Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Basics - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Overview PostgreSQL, often simply Postgres, is\u00a0an object-relational database management\u00a0system (ORDBMS) with an emphasis on\u00a0extensibility and standards compliance. As a\u00a0database server, its primary functions are to\u00a0store data securely and return that data in\u00a0response to requests from other software\u00a0applications. It can handle workloads ranging\u00a0from small single-machine applications to\u00a0large Internet-facing applications (or for data\u00a0warehousing) with many concurrent users; …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-14T08:43:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-09T22:59:52+00:00\" \/>\n<meta name=\"author\" content=\"Vaibhav Krishna\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vaibhav Krishna\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/\"},\"author\":{\"name\":\"Vaibhav Krishna\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/6c10f95f66ae2b4026552b02018b18b7\"},\"headline\":\"PostgreSQL Basics\",\"datePublished\":\"2018-08-14T08:43:39+00:00\",\"dateModified\":\"2018-11-09T22:59:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/\"},\"wordCount\":411,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/\",\"name\":\"PostgreSQL Basics - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2018-08-14T08:43:39+00:00\",\"dateModified\":\"2018-11-09T22:59:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL Basics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/6c10f95f66ae2b4026552b02018b18b7\",\"name\":\"Vaibhav Krishna\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/482ae666004473e37e849efeedbf7111152f716f6e9fc6852074d49536796697?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/482ae666004473e37e849efeedbf7111152f716f6e9fc6852074d49536796697?s=96&d=mm&r=g\",\"caption\":\"Vaibhav Krishna\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/vaibhavkrishna\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL Basics - Database Tutorials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL Basics - Database Tutorials","og_description":"Overview PostgreSQL, often simply Postgres, is\u00a0an object-relational database management\u00a0system (ORDBMS) with an emphasis on\u00a0extensibility and standards compliance. As a\u00a0database server, its primary functions are to\u00a0store data securely and return that data in\u00a0response to requests from other software\u00a0applications. It can handle workloads ranging\u00a0from small single-machine applications to\u00a0large Internet-facing applications (or for data\u00a0warehousing) with many concurrent users; …","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-14T08:43:39+00:00","article_modified_time":"2018-11-09T22:59:52+00:00","author":"Vaibhav Krishna","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vaibhav Krishna","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/"},"author":{"name":"Vaibhav Krishna","@id":"https:\/\/dbtut.com\/#\/schema\/person\/6c10f95f66ae2b4026552b02018b18b7"},"headline":"PostgreSQL Basics","datePublished":"2018-08-14T08:43:39+00:00","dateModified":"2018-11-09T22:59:52+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/"},"wordCount":411,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/","name":"PostgreSQL Basics - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2018-08-14T08:43:39+00:00","dateModified":"2018-11-09T22:59:52+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/postgresql-basics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL Basics"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/6c10f95f66ae2b4026552b02018b18b7","name":"Vaibhav Krishna","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/482ae666004473e37e849efeedbf7111152f716f6e9fc6852074d49536796697?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/482ae666004473e37e849efeedbf7111152f716f6e9fc6852074d49536796697?s=96&d=mm&r=g","caption":"Vaibhav Krishna"},"url":"https:\/\/dbtut.com\/index.php\/author\/vaibhavkrishna\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/109"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=1650"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1650\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=1650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=1650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=1650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}