PostgreSQL – Show List of Master Tables

Please note the following commands:

• \list or \l: list all databases
• \dt: list all tables in the current database using your search_path
• \dt *.: list all tables in the current database regardless your search_path

You will never see tables in other databases, these tables aren't visible. You have to connect to the correct database to see its tables (and other objects).

To switch databases:

\connect database_name or \c database_name

See the manual about psql.

The problem may be a namespace issue. You can \dn to list namespaces.

Keep in mind that by default \d only lists relations in the search path, and you can run show search_path to see what this is.

If you want to list relations in a namespace outside the search path, \d mynamespace.* will list them and their attributes. You can also:

set search_path = 'mynamespace';
\d
set search_path = 'public';

To temporarily change the search path for purposes of using \d