SQL

how to list columns for particular tables in postgresql

SELECT *
  FROM information_schema.columns
 WHERE table_schema = 'your_schema'
   AND table_name   = 'your_table'
     ;

list columns in table postgres

-- Good for quickly reminding you of what columns exist.
SELECT * FROM mytable WHERE 1=0;

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;

list all tables in postgres

c database_name

dt