AWS Redshift: column names for table, column delimited

aws_redshift_column_names.sql

-- LISTAGG only works on user created tables, so need this hack
create table #cols (column_name varchar(255), ordinal_position int)

insert into #cols
select column_name, ordinal_position 
from SVV_COLUMNS 
where table_name = '<table name>' and table_schema = '<schema name>'

select LISTAGG(column_name, ', ') within group (order by ordinal_position) from #cols

drop table #cols