Skip site navigation (1) Skip section navigation (2)

Re: Simple list tables question

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Mihai TanasescuDate: 2004-03-21 18:51:27
Subject: Re: Simple list tables question
Previous:From: joseph speigleDate: 2004-03-21 18:05:30
Subject: Re: Creating Functions & Triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group