Re: tables are not listable by \dt

On Jul 2, 2007, at 10:04 AM, Rajarshi Guha wrote:

> 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.

Thanks to posters - it was indeed an error with the search path.

-------------------------------------------------------------------
Rajarshi Guha  <rguha@indiana.edu>
GPG Fingerprint: 0CCA 8EE2 2EEB 25E2 AB04  06F7 1BB9 E634 9B87 56EE
-------------------------------------------------------------------
If you don't get a good night kiss, you get Kafka dreams."
                 -Hobbes