PostgreSQL 11 Administration Cookbook

How to do it...

From any interface, type the following SQL command:

SELECT count(*) FROM information_schema.tablesWHERE table_schema NOT IN ('information_schema','pg_catalog');

You can also look at the list of tables directly, and judge whether the list is a small or large number.

In psql, you can see your own tables by using the following command:

$ psql -c "\d"        List of relations Schema |   Name   | Type  |  Owner  --------+----------+-------+---------- public | accounts | table | postgres public | branches | table | postgres

In pgAdmin 4, you can see the tables in the tree view on the left-hand side, as shown in the following screenshot: