select datname, datcollate
from pg_database where datname = 'dbname';select table_schema,
table_name,
column_name,
collation_name
from information_schema.columns
where table_name = 'test_table'
order by table_schema,
table_name,
ordinal_position;