{"id":363,"date":"2018-06-20T12:17:46","date_gmt":"2018-06-20T12:17:46","guid":{"rendered":"http:\/\/dbtut.com\/?p=363"},"modified":"2020-07-01T12:51:59","modified_gmt":"2020-07-01T12:51:59","slug":"how-to-create-database-on-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/","title":{"rendered":"How To Create Database On PostgreSQL"},"content":{"rendered":"<p><span style=\"font-size: 1.125rem; font-family: var(--text-font);\">You can create database on PostgreSQL easily. <\/span>You can specify some parameters when creating database. If you want more about Postgresql you may want to read our other articles from the below link.<\/p>\n<p><a href=\"https:\/\/dbtut.com\/index.php\/category\/postgres\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/dbtut.com\/index.php\/category\/postgres\/<\/a><\/p>\n<p>There are many ways to create database on postgresql. You can find the details in the below examples.<\/p>\n<h3>How do I create a new database in PostgreSQL?<\/h3>\n<pre class=\"lang:default decode:true\">CREATE DATABASE test;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/502.png\" width=\"451\" height=\"88\"><\/p>\n<h4>Postgres create database with owner<\/h4>\n<p>In this example, we also specify the owner when creating the database.<\/p>\n<pre class=\"lang:default decode:true\">CREATE DATABASE test OWNER testUser;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/181.png\" width=\"598\" height=\"86\"><\/p>\n<h3>Postgres create database with tablespace<\/h3>\n<p>In this example, we also specify which tablespace to use when creating the database.<\/p>\n<pre class=\"lang:default decode:true \">CREATE DATABASE test TABLESPACE x;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/593.png\" width=\"545\" height=\"94\"><\/p>\n<h4>Postgres create database with encoding<\/h4>\n<p>In this example, we specify the ENCODING option when creating the database.<\/p>\n<pre class=\"lang:default decode:true\">CREATE DATABASE test ENCODING 'UTF8';<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/982-1.png\" width=\"573\" height=\"88\"><\/p>\n<h4>Postgres create database with template<\/h4>\n<p>In this example, when creating a database, we specify which template the database will be based on.<\/p>\n<pre class=\"lang:default decode:true\">CREATE DATABASE test TEMPLATE template3;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/122.png\" width=\"585\" height=\"80\"><\/p>\n<p>Lastly, you can use all the parameters together you see in the examples above.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_363\" class=\"pvc_stats all  \" data-element-id=\"363\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>You can create database on PostgreSQL easily. You can specify some parameters when creating database. If you want more about Postgresql you may want to read our other articles from the below link. https:\/\/dbtut.com\/index.php\/category\/postgres\/ There are many ways to create database on postgresql. You can find the details in the below examples. How do I &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_363\" class=\"pvc_stats all  \" data-element-id=\"363\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":15649,"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":[403,406,404,405,9714,9715,414,413,408,411,9753,9735,9736,9738,9723,9722,9751,9721,9731,9744,9728,9729,9739,9719,9720,9718,9743,9726,9734,9749,9725,9724,9752,9732,9747,9733,9730,9716,9745,9727,9737,9740,9750,9748,9741,9717,9742,9746,409,410,407,412],"class_list":["post-363","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-create-database","tag-create-database-on-postgres","tag-create-database-on-postgresql","tag-create-postgres-database","tag-create-postgres-database-with-owner","tag-create-postgres-database-with-tablespace","tag-database-owner","tag-database-owner-postgresql","tag-encoding","tag-encoding-on-postgresql","tag-how-do-i-create-a-new-database-in-postgresql","tag-how-to-create-a-postgresql-database-with-different-encoding","tag-how-to-create-database-in-postgres","tag-postgres-create-database","tag-postgres-create-database-encoding","tag-postgres-create-database-encoding-utf8","tag-postgres-create-database-from-command-line","tag-postgres-create-database-owner-user","tag-postgres-create-database-with-different-encoding","tag-postgres-create-database-with-different-template","tag-postgres-create-database-with-encoding","tag-postgres-create-database-with-encoding-utf8","tag-postgres-create-database-with-owner","tag-postgres-create-database-with-owner-command-line","tag-postgres-create-database-with-owner-example","tag-postgres-create-database-with-tablespace","tag-postgres-create-database-with-template","tag-postgres-create-database-with-utf8-encoding","tag-postgres-databases-with-different-encoding","tag-postgresql-create-database-command-line","tag-postgresql-create-database-encoding","tag-postgresql-create-database-encoding-utf8","tag-postgresql-create-database-from-command-line","tag-postgresql-create-database-with-different-encoding","tag-postgresql-create-database-with-different-template","tag-postgresql-create-database-with-encoding","tag-postgresql-create-database-with-encoding-utf8","tag-postgresql-create-database-with-tablespace","tag-postgresql-create-database-with-template","tag-postgresql-create-database-with-utf8-encoding","tag-postgresql-create-local-database","tag-psql-create-database","tag-psql-create-database-command-line","tag-psql-create-database-with-different-template","tag-psql-create-database-with-encoding","tag-psql-create-database-with-owner","tag-psql-create-database-with-tablespace","tag-psql-create-database-with-template","tag-tablespace","tag-tablespace-on-postgresql","tag-template","tag-template-on-postgresql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":191,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create Database On PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Create Database On PostgreSQL\" \/>\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\/06\/20\/how-to-create-database-on-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create Database On PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Create Database On PostgreSQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-20T12:17:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-01T12:51:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png\" \/>\n\t<meta property=\"og:image:width\" content=\"616\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Create Database On PostgreSQL\",\"datePublished\":\"2018-06-20T12:17:46+00:00\",\"dateModified\":\"2020-07-01T12:51:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/\"},\"wordCount\":165,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png\",\"keywords\":[\"CREATE DATABASE\",\"create database on postgres\",\"CREATE DATABASE ON PostgreSQL\",\"create postgres database\",\"Create postgres database with owner\",\"create postgres database with tablespace\",\"database owner\",\"database owner postgresql\",\"ENCODING\",\"encoding on postgresql\",\"How do I create a new database in PostgreSQL?\",\"How to Create a PostgreSQL database with different Encoding\",\"How to create database in postgres\",\"Postgres create database\",\"postgres create database encoding\",\"postgres create database encoding utf8\",\"postgres Create database from command line\",\"postgres create database owner user\",\"postgres create database with different encoding\",\"Postgres create database with different template\",\"postgres create database with encoding\",\"postgres create database with encoding utf8\",\"Postgres create database with owner\",\"postgres create database with owner command line\",\"postgres create database with owner example\",\"postgres create database with tablespace\",\"Postgres create database with template\",\"postgres create database with utf8 encoding\",\"Postgres databases with different encoding\",\"PostgreSQL create database command line\",\"postgresql create database encoding\",\"postgresql create database encoding utf8\",\"postgresql create database from command line\",\"postgresql create database with different encoding\",\"Postgresql create database with different template\",\"postgresql create database with encoding\",\"postgresql create database with encoding utf8\",\"postgresql create database with tablespace\",\"Postgresql create database with template\",\"postgresql create database with utf8 encoding\",\"PostgreSQL create local database\",\"psql create database\",\"PSQL Create Database Command Line\",\"Psql create database with different template\",\"psql create database with encoding\",\"Psql create database with owner\",\"psql create database with tablespace\",\"Psql create database with template\",\"TABLESPACE\",\"tablespace on postgresql\",\"TEMPLATE\",\"template on postgresql\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/\",\"name\":\"How To Create Database On PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png\",\"datePublished\":\"2018-06-20T12:17:46+00:00\",\"dateModified\":\"2020-07-01T12:51:59+00:00\",\"description\":\"How To Create Database On PostgreSQL\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png\",\"width\":616,\"height\":338},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create Database On PostgreSQL\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create Database On PostgreSQL - Database Tutorials","description":"How To Create Database On PostgreSQL","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\/06\/20\/how-to-create-database-on-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How To Create Database On PostgreSQL - Database Tutorials","og_description":"How To Create Database On PostgreSQL","og_url":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2018-06-20T12:17:46+00:00","article_modified_time":"2020-07-01T12:51:59+00:00","og_image":[{"width":616,"height":338,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Create Database On PostgreSQL","datePublished":"2018-06-20T12:17:46+00:00","dateModified":"2020-07-01T12:51:59+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/"},"wordCount":165,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png","keywords":["CREATE DATABASE","create database on postgres","CREATE DATABASE ON PostgreSQL","create postgres database","Create postgres database with owner","create postgres database with tablespace","database owner","database owner postgresql","ENCODING","encoding on postgresql","How do I create a new database in PostgreSQL?","How to Create a PostgreSQL database with different Encoding","How to create database in postgres","Postgres create database","postgres create database encoding","postgres create database encoding utf8","postgres Create database from command line","postgres create database owner user","postgres create database with different encoding","Postgres create database with different template","postgres create database with encoding","postgres create database with encoding utf8","Postgres create database with owner","postgres create database with owner command line","postgres create database with owner example","postgres create database with tablespace","Postgres create database with template","postgres create database with utf8 encoding","Postgres databases with different encoding","PostgreSQL create database command line","postgresql create database encoding","postgresql create database encoding utf8","postgresql create database from command line","postgresql create database with different encoding","Postgresql create database with different template","postgresql create database with encoding","postgresql create database with encoding utf8","postgresql create database with tablespace","Postgresql create database with template","postgresql create database with utf8 encoding","PostgreSQL create local database","psql create database","PSQL Create Database Command Line","Psql create database with different template","psql create database with encoding","Psql create database with owner","psql create database with tablespace","Psql create database with template","TABLESPACE","tablespace on postgresql","TEMPLATE","template on postgresql"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/","name":"How To Create Database On PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png","datePublished":"2018-06-20T12:17:46+00:00","dateModified":"2020-07-01T12:51:59+00:00","description":"How To Create Database On PostgreSQL","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/06\/Ads\u0131z-48.png","width":616,"height":338},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/06\/20\/how-to-create-database-on-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Create Database On PostgreSQL"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/363","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=363"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/363\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/15649"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}