[PostgreSQL]取欄位型態名稱

select column_name, data_type, character_maximum_length from information_schema.columns
where
 table_schema='public'
 and table_name = 'table_name'