CREATE SCHEMA Creating a schema using command: Syntax:


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



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.
Please follow and like us:
Content Protection by