Re: Simple list tables question

On Sun, Mar 21, 2004 at 02:21:51PM +0200, Mihai Tanasescu wrote:
> Hello,
>
> I've been a mysql user for about 2 years and I decided to try Postgre
> SQL out.
>
> I have the following problem that I'm trying to figure out:
>
> - in mysql as user root I can connect to any databases not owned by
> myself and I can list the tables they contain
> - in postgre I have created another database owned by user "bbstatus"
> 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.

Note how the tables in the first \dt are in schema bbstatus which by
default only user bbstatus will see. \dt *.* should list all tables
IIRC.

Did you intend for those tables to be in their own schema?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
> http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow