PostgreSQL is a object relational database management system and supports different types of operating system. In PostgreSQL Create Database is created using pgAdmin3. And these pgAdmin is a graphical interface, that provides the user to easily understand and to access the database features conveniently. PostgreSQL allows a clients for executing multiple number of action based on the given code, that contains exchanging multiples externally beyond the code source. These are additionally contain the necessity which are related to the copyright that display in each and every software that are duplicated. PostgreSQL supports all the standard versions such as PL/Python, PL/Tcl, PL/pgSQL, PL/Perl. PostgreSQL additionally supports multi version concurrency control(MVCC).
PostgreSQL Create Database Example
Description
By viewing the below steps of PostgreSQL Create Database, the concept of creating a new database in postgreSQL can easily understand.
Step - 1
Open pgAdmin 3.
Step - 2
On the left side the postgreSQL server has been listed.
Step - 3
Expand the server,then postgreSQL 9.6 and local host along with port number 5432 has been listed.
Step - 4
Expand postgreSQL 9.6 it will display a number of collections.
Step - 5
Right click on the database and select New Database option.
Step - 6
Here a new database has been created with name SQLDB.
Step - 7
Expand database then new SQLDB database has been successfully created.
Summary
Key Points
PostgreSQL Create Database - Means creating a new database in PostgreSQL server.
PostgreSQL Create Database - Can also be performed in command prompt.