Rajarshi Guha <rguha(at)indiana(dot)edu> 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