Re: [GENERAL] tables are not listable by \dt

2007-07-02 Thread Rajarshi Guha
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

Re: [GENERAL] tables are not listable by \dt

2007-07-02 Thread Mikko Partio
On 7/2/07, Rajarshi Guha <[EMAIL PROTECTED]> 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 th

Re: [GENERAL] tables are not listable by \dt

2007-07-02 Thread Tom Lane
Rajarshi Guha <[EMAIL PROTECTED]> 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 > SELE

Re: [GENERAL] tables are not listable by \dt

2007-07-02 Thread Michael Fuhr
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 foun

[GENERAL] tables are not listable by \dt

2007-07-02 Thread Rajarshi Guha
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 relpag