How to view table definition in Redshift Database

You can query the PG_TABLE_DEF system catalog view to view the definition of a table in Redshift database.

SELECT * FROM pg_table_def WHERE tablename='your_table_name';
See also  How to get information about an IAM role