PostgreSQL CREATE SCHEMA

by

CREATE SCHEMA
Creating a schema using command:
Syntax: 

CREATE SCHEMA name;

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

Example: 

CREATE SCHEMA students;

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

Creating a schema using UI:
To create a schema in PostgreSQL using pgAdmin, follow the below steps.

  • Go to start menu.
  • Open pgAdmin.
  • Connect PostgreSQL to the localhost server.
  • Click on the plus icon to expand the databases.
  • Expand the selected database.
  • Right-click on the selected database.
  • Click on the “New schema” to create a new schema.
  • Add a name to the created schema.

 

PostgreSQL Create Table in Schema:

To create a table in a schema in PostgreSQL, follow the below steps.

  • Expand the selected schema.
  • Right-click on the selected table.
  • Click on the “New Table” to create a new table.
  • To add columns, click on the “Columns” and ADD buttons.

 

Drop PostgreSQL Schema:

To drop or eliminate a schema in PostgreSQL, follow the below steps.

  • Click on the schema.
  • Right-click on the selected schema.
  • You will see the following page.
  • Click on the Drop option.
  • Click on the “Yes” button.
  • If there is an ERROR while dropping, drop the dependent object first.
  • Right-click on the selected schema.
  • Click on the “Drop cascaded”.
  • Click “Yes” to delete the dependent objects.
  • On deleting the dependent objects the schema will be automatically deleted.

 

Advantages of using a Schema:

A schema add a lot of benefits for the users, and thus is highly recommended. Some of these advantages are:

  • It facilitates multiple users to use one database without interfering with each other.
  • To make the Database objects more manageable, they are organized into logical groups.
  • To avoid collision with the names of other objects, the third party schemas can be put into separate schemas.