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
In response to
pgsql-novice by date
|Next:||From: Mihai Tanasescu||Date: 2004-03-21 18:51:27|
|Subject: Re: Simple list tables question|
|Previous:||From: joseph speigle||Date: 2004-03-21 18:05:30|
|Subject: Re: Creating Functions & Triggers|