AWS bytes

You can use the below command to rename an existing sequence where seq_name is the current name of the sequence

You can use the below sql statement to move sequence to a different schema. Here seq_name is the name of

Below is the syntax to rename a tablespace in Postgresql database where tablespace_name is the current name of the tablespace

You can change the owner of a Tablespace as shown below in Postgres database where tablespace_name is the name of

You can query the system catalog view view_table_usage to identify all the tables used by a view in Postgres database.

You can query the system catalog table pg_namespace to view all the schemas in Postgres database. SELECT nspname, oid from

You can query the system catalog table ‘columns’ to view all the columns of a table and their data types

You can query the system catalog table ‘views’ to list all the views of a postgres database as shown below:

Syntax to drop a table in Postgres: DROP TABLE tablename; Syntax to drop multiple tables in Postgres: DROP TABLE tablename1,

You can query the system catalog table ‘views’ to get the definition of a view in postgres database. SELECT view_definition