SQL

get all tables postgres

SELECT * FROM pg_catalog.pg_tables;

show all public tables postgres

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

show table postgres command

PostgreSQL show tables command
	
dt

list all tables in postgres

c database_name

dt

postgresql show tables

c database_name -> to select the database
dt -> to show the tables in the current database

show table details postgresql

d table

postgresql show tables

SELECT *
FROM pg_catalog.pg_tables
WHERE schemaname != 'pg_catalog' AND 
    schemaname != 'information_schema';
Code language: SQL (Structured Query Language) (sql)