SELECT
TABLE_NAME,
COLUMN_NAME,
data_type,
udt_name
FROM
information_schema. COLUMNS
WHERE
table_schema = 'public'
AND TABLE_NAME = '表名'
SELECT
TABLE_NAME,
COLUMN_NAME,
data_type,
udt_name
FROM
information_schema. COLUMNS
WHERE
table_schema = 'public'
AND TABLE_NAME = '表名'本文标题：PostgreSQL 查询表的列和类型
本文链接：https://www.haomeiwen.com/subject/pmalxktx.html
网友评论