tables are not listable by \dt

On Mon, Jul 02, 2007 at 10:04:21AM -0400, 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.

Are the tables in schemas that are in your search_path?

--
Michael Fuhr

Rajarshi Guha <rguha@indiana.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

On 7/2/07, Rajarshi Guha <rguha@indiana.edu> 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

Are you using the 8.2 version of psql?

Regards

MP

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