How to Change the Schema Name in PostgreSQL

8 Nov by Faruk Erdem

How to Change the Schema Name in PostgreSQL

We may want to change the schema name because of some needs. For this we can use the following script.

First, we list the schemes with the command \dn as follows.

 

We change the name of the faruk scheme with the help of the following command.

 

We changed the schema name to ERDEM. Use \dn command to check whether the name has changed.

Leave a Reply

Your email address will not be published. Required fields are marked *