archive

Get Column Names & Data Type (Postgres)

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 ~ '^(dams_pt)$' AND
pg_catalog.pg_table_is_visible(c.oid)
);

Comments are closed.