From: | Mihai Tanasescu <Mihai(dot)Tanasescu(at)skyraven(dot)pcnet(dot)ro> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Simple list tables question |
Date: | 2004-03-21 18:29:38 |
Message-ID: | 405DDF12.9080702@skyraven.pcnet.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(dot)Tanasescu(at)skyraven(dot)pcnet(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mihai Tanasescu | 2004-03-21 18:51:27 | Re: Simple list tables question |
Previous Message | joseph speigle | 2004-03-21 18:05:30 | Re: Creating Functions & Triggers |