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

Re: Simple list tables question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mihai Tanasescu <Mihai(dot)Tanasescu(at)skyraven(dot)pcnet(dot)ro>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Simple list tables question
Date: 2004-03-21 16:24:50
Message-ID: 25781.1079886290@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Kevin LohkaDate: 2004-03-21 17:21:57
Subject: Re: Creating Functions & Triggers
Previous:From: Tom LaneDate: 2004-03-21 16:18:29
Subject: Re: Creating Functions & Triggers

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