How to get the column names of a table in Redshift

You can list all the columns of a table using below query where tablename is the name of the table.

select * from information_schema.columns where table_name = 'tablename';

See also  How to list all the users of a group in Redshift database