PostgreSQL: \dt

https://www.postgresql.org/docs/current/app-psql.html

\dt

                           List of relations
 Schema |               Name                | Type  |       Owner
--------+-----------------------------------+-------+-------------------
 public | yourtable1                            | table | rds_master
 public | yourtable2                            | table | rds_master
 public | yourtable3                            | table | other_user
 public | yourtable4                            | table | rds_master

List tables from all schemas (if *.* is omitted will only show SEARCH_PATH ones)

\dt *.*

List all foreign tables 
\dE[S+]

Related queries

• SELECT tablename AS TABLE FROM pg_tables WHERE schemaname = 'public';
• SELECT * FROM information_schema.tables;

Related

• Connect to a database
• Show databases
• Create database
• Delete database
• Create user
• List users
• List databases
• List tables: show tables
• GRANT

See also

• PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, --version, --help, PL/pgSQL
• SQL, NewSQL: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint

https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546

https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546

https://tableplus.com/blog/2018/07/postgresql-how-to-list-all-tables-excluding-views.html

https://tableplus.com/blog/2018/04/postgresql-how-to-list-all-tables.html