Re: Simple list tables question

Thanks,
that worked...
I'm now looking through the docs to see how I can change the search path.




Tom Lane wrote:

> Mihai Tanasescu <Mihai.Tanasescu@xxxxxxxxxxxxxxxxx> writes:
>  
>
> >    If I login with user bbstatus to database bbstatus then I can do a
> > "\dt" and show the tables it contains but if I login with user postgres
> > which is a superuser and I try a "\dt" I get no results.
> >    
> It's got nothing to do with permissions --- it has to do with your
> search path.  Schema bbstatus isn't in postgres' default search path
> and so by default \dt doesn't show its contents.
>
> You could see 'em with \dt *.* or \dt bbstatus.*, or you could set
> search_path to include bbstatus.
>
>                         regards, tom lane
>  
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend