The number of tables in a relational database is a good measure of the complexity of a database, so it is a simple way to get to know any database.
In this recipe, we will show you how to compute the number of tables.
From any interface, type the following SQL command:
SELECT count(*) FROM information_schema.tables WHERE 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 using the following command:
postgres@ebony:~/8.3/main$ psql -c "\d" List of relations Schema | Name | Type | Owner --------+----------+-------+---------- public | accounts | table | postgres ...