how to look for tables in psql code example
Example 1: get all tables postgres
SELECT * FROM pg_catalog.pg_tables;
Example 2: show details of table postgres
postgres=# \d tablename;
SELECT * FROM pg_catalog.pg_tables;
postgres=# \d tablename;