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;