In this article, we will see how to find number of tables in PostgreSQL Database.
The number of tables in a relational database is good measure of the complexity of a database, so it is a simple way to get know any database.
Query to find number of tables in PostgreSQL Database:
select count(*) from information_schema.tables where table_schema not in ('information_schema','pg_catalog');
To get user tables, run the meta-command \dt.