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;