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  [Amazon](500310) Invalid operation: permission denied for relation