Category: Postgresql

You can revoke the super user privileges previously granted to a database user by running the below sql command where username is

Run the below command to change the owner of a postgres schema where schemaname is the name of the schema

Below is the command to rename a schema in postgres database where ‘schemaname‘ is the current name of the schema

Postgres database provides a gen_random_uuid() function to generate a random uuid. This function can be used in a sql insert

Run the below sql command to query the version of your postgres database. select version();

Run the below sql query to view all the tables of a schema in Postgresql database where schemaname is the

PostgreSQL does not provide a ‘DESCRIBE’ command like Oracle. You can however describe a table in Postgres either by querying