xxxxxxxxxx
SELECT column_name
FROM information_schema.columns
WHERE table_schema = 'public'
AND table_name = 'your_table_name';
xxxxxxxxxx
SELECT
table_name,
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name = 'city';Code language: SQL (Structured Query Language) (sql)