AWS Redshift Useful Commands

This is basically for me but should anyone else find them useful, here is a set of commands I find useful in AWS Redshift.

I am going to keep adding as I run into them.

Show all Tables 

SELECT DISTINCT tablename
FROM pg_table_def
WHERE schemaname = 'public'
ORDER BY tablename;

Describe a table 

desc <<TABLENAME>>; i.e desc mytablename;