[redshift]查看表格的sort key

https://docs.aws.amazon.com/ja_jp/redshift/latest/dg/r_search_path.html

set search_path to '$user', avgpop_jp
;
SELECT *
FROM pg_table_def
WHERE schemaname = 'avgpop_jp' 
and tablename='m_kokusei_2014'

set search_path to avgpop_jp;
select schemaname,tablename,"column", type, encoding, distkey, sortkey, "notnull"
from pg_table_def
where sortkey <> 0;