How To Create Database On PostgreSQL

dbtut June 20, 2018 PostgreSQL

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 create a new database in PostgreSQL?

CREATE DATABASE test;

1	CREATE DATABASE test;

Postgres create database with owner

In this example, we also specify the owner when creating the database.

CREATE DATABASE test OWNER testUser;

1	CREATE DATABASE test OWNER testUser;

Postgres create database with tablespace

In this example, we also specify which tablespace to use when creating the database.

CREATE DATABASE test TABLESPACE x;

1	CREATE DATABASE test TABLESPACE x;

Postgres create database with encoding

In this example, we specify the ENCODING option when creating the database.

CREATE DATABASE test ENCODING 'UTF8';

1	CREATE DATABASE test ENCODING 'UTF8';

Postgres create database with template

In this example, when creating a database, we specify which template the database will be based on.

CREATE DATABASE test TEMPLATE template3;

1	CREATE DATABASE test TEMPLATE template3;

Lastly, you can use all the parameters together you see in the examples above.

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux