pgslq表的字段类型,如何在PostgreSQL中获取表的列表列名称和数据类型？

With the following query, we can get a list of column names and datatype of a table in PostgreSQL.

解决方案SELECT

a.attname as "Column",

pg_catalog.format_type(a.atttypid, a.atttypmod) as "Datatype"

FROM

pg_catalog.pg_attribute a

WHERE

a.attnum > 0

AND NOT a.attisdropped

AND a.attrelid = (

SELECT c.oid

FROM pg_catalog.pg_class c

LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace

WHERE c.relname ~ '^(hello world)$'

AND pg_catalog.pg_table_is_visible(c.oid)

);