pgsql 查询对应模式下的表结构语句

select
    table_name,
    column_name,
    data_type,
    udt_name,
    table_catalog,
    table_schema,
    table_name,
    column_name,
    ordinal_position,
    column_default
from
    information_schema. columns
where
    table_schema = '{schema}'
and table_name = '{table}'