Re: Simple list tables question

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