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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to