CREATE DATABASE in PostgreSQL

by

CREATE DATABASE
Creating a database using command:

Syntax: 

CREATE DATABASE name;

Parameters:
name: It is used to specify the name of the database to be created.

Example: 

CREATE DATABASE students;

Explanation:
A new database will be created with the name ‘students’.

Creating a database using UI:

  • Go to start menu.
  • Click on the pgAdmin.
  • Right-click on the PostgreSQL 9.0.
  • Connect PostgreSQL to the localhost server.
  • Right-click on the database.
  • Select a new database.
  • Type the database name in the pop-up generated.
  • Click on the “OK” button.

A new database is thus created.

 

Creating a database using the Query tool:

  • Go to start menu.
  • Click on the pgAdmin.
  • Left-click on the database.
  • Select the tools on the topmost line.
  • Left-click on the tool to get the Query tool.
  • Click on the query tool.
  • Put the “CREATE DATABASE” query here.
  • For example; CREATE DATABASE students;
  • Click on the “Play” button.

The query will thus be executed.