PostgreSQL-----No relations found.

This article may be wrong, has not been carefully studied

Error running \d:

No relations found.

\d只显示可见的表，也就是该数据库的schema在search_path中。

SHOW Search_path;

If not, set it up:

SET Search_path= Tran;

Where Tran is the schema to query.

If \d still goes wrong, check the access permissions:

\dn+

If the output:

                          List of schemas  Name  |  Owner   |  Access Privileges   |       Description       --------+----------+----------------------+------------------------| Postgres | postgres=uc/postgres+| Standard public schema        |          | =uc/postgres         |   Tran   | Postgres | | | |                      |

Tran the line of access privileges is empty, add permissions:

Grant all on the SCHEMA tran to public;

Run \dn+, then output:

                          List of schemas  Name  |  Owner   |  Access Privileges   |       Description       --------+----------+----------------------+------------------------| Postgres | postgres=uc/postgres+| Standard public schema        |          | =uc/postgres         |   Tran   | Postgres | postgres=uc/postgres+|         |          | =uc/postgres         

PostgreSQL-----No relations found.