SQL

get all tables postgres

SELECT * FROM pg_catalog.pg_tables;

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;

show tables postgresql

SELECT *
FROM INFORMATION_SCHEMA.tables
where table_schema = 'public';

list all tables in postgres schema

dt schema_name.*

show all tables postgres

dt
# show list of tables in postgres

psql list tables in schema

=> dt *.*

psql list tables in schema

=> dt public.*

list all tables in postgres

c database_name

dt