CODE EXAMPLE FOR SQL

list all tables and columns in postgresql

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;