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
 public | branches | table | postgres

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

PostgreSQL stores information about the database in catalog tables...