Search
 
SCRIPT & CODE EXAMPLE
 
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;
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #list #tables #columns #postgresql
ADD COMMENT
Topic
Name
4+5 =