select count(*)
from information_schema.tables;
Or if you want to find the number of tables only for a specific schema:
select count(*)
from information_schema.tables
where table_schema="public";
select count(*)
from information_schema.tables;
Or if you want to find the number of tables only for a specific schema:
select count(*)
from information_schema.tables
where table_schema="public";