PostgreSQL 查询表的列和类型

SELECT
    TABLE_NAME,
    COLUMN_NAME,
    data_type,
    udt_name
FROM
    information_schema. COLUMNS
WHERE
    table_schema = 'public'
AND TABLE_NAME = '表名'