PostgreSQL - SPLessons

PostgreSQL Create Database

Chapter 6

SPLessons 5 Steps, 3 Clicks
5 Steps - 3 Clicks

PostgreSQL Create Database

PostgreSQL Create Database

shape Description

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

shape Description

By viewing the below steps of PostgreSQL Create Database, the concept of creating a new database in postgreSQL can easily understand.

shape Step - 1

Open pgAdmin 3.

shape Step - 2

On the left side the postgreSQL server has been listed.

shape Step - 3

Expand the server,then postgreSQL 9.6 and local host along with port number 5432 has been listed.

shape Step - 4

Expand postgreSQL 9.6 it will display a number of collections.

shape Step - 5

Right click on the database and select New Database option.

shape Step - 6

Here a new database has been created with name SQLDB.

shape Step - 7

Expand database then new SQLDB database has been successfully created.

Summary

shape Key Points

  • PostgreSQL Create Database – Means creating a new database in PostgreSQL server.
  • PostgreSQL Create Database – Can also be performed in command prompt.