SELECT *
FROM information_schema.columns
WHERE table_schema = 'your_schema'
AND table_name = 'your_table'
;
-- Good for quickly reminding you of what columns exist.
SELECT * FROM mytable WHERE 1=0;
CREATE VIEW table_column_info AS
SELECT table_name, STRING_AGG(column_name, ', ') AS columns
FROM information_schema.columns
WHERE table_schema = 'public'
GROUP BY table_name;
SELECT * FROM table_column_info;
c database_name
dt