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}'
pgsql 查询对应模式下的表结构语句
发布时间 2023-11-14 17:38:11作者: Young_Mo