Rajarshi Guha <rguha@xxxxxxxxxxx> writes: > Hi, we recently upgraded our Postgres instllation from 7.4 to 8.2 by > doing a dump and restore. Howveer after logging into the database (as > a user that is not the superuser) and doing \dt I get the error: > No relations found > But when I do > SELECT relname, relpages FROM pg_class ORDER BY relpages DESC; > I get a list of the tables and their sizes. \dt does joins to pg_roles and pg_namespace ... are those nonempty? What have you got search_path set to? regards, tom lane
