Category: Redshift

Check the current owner of the tables using the below query where schema_name is the name of the schema in

Below are the steps to move table from one schema to another in Redshift database. Step 1: Create table in

Below is the syntax to drop a column from a table in Redshift database where tablename is the name of

svv_external_schemas system catalog view provides list of all external schemas in your Redshift database. SELECT * FROM svv_external_schemas;

Step1: Download and install psql tool from https://www.postgresql.org/download/ for your version of OS. For Linux: sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Run the below query to obtain the ddl of an external table in Redshift database. If the view v_generate_external_tbl_ddl is not

Run the below query to obtain the ddl of a table in Redshift database. select * from admin.v_generate_tbl_ddl where schemaname

Run the below query to lit all the materialized views in a schema in Redshift database. select name from STV_MV_INFO

Run the below query to return all tables and views of a schema in Redshift database where schemaname is the

Run the below query to return the name of the database you are currently connected to. select current_database();