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@skyraven.pcnet.ro> 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
>
>