Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will explain how to change the owner while creating or after creating a Postgresql schema.
If you have created a schema in PostgreSQL but have not changed its owner, or if you want to specify a different owner while creating the schema, you can follow the steps below.
To change the owner when creating a schema:
1 | CREATE SCHEMA aa AUTHORIZATION faruk; |
To change the owner after creating a schema:
1 | ALTER SCHEMA d1 OWNER TO faruk4; |
