Re: why schema name is same as username behaves different then ot - Mailing list pgsql-admin

From Jie Liang
Subject Re: why schema name is same as username behaves different then ot
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB1E192C@mail01.stbernard.com
Whole thread Raw
List pgsql-admin
Got it.
Thank you.


Jie

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, December 05, 2002 2:58 PM
To: Jie Liang
Cc: 'Bruce Momjian'; pgsql-admin@postgresql.org
Subject: Re: why schema name is same as username behaves different then
others


Jie Liang <jie@stbernard.com> writes:
> ####I expect to see something like:

You're neglecting the effects of search path.  \dt only shows what's
visible in your search path.  (IIRC, \dt *.* is the easiest way to
see all tables regardless of search path.)

> #### it seems if schema name is same as username then
> #### it will shadow the objects in the public schema that have same name.

That's what it's supposed to do, and yes this is documented, and yes
you can change it if you don't like it.  Read about search_path.

            regards, tom lane

pgsql-admin by date:

Previous
From: Joe Conway
Date:
Subject: Re: why schema name is same as username behaves different
Next
From: Jie Liang
Date:
Subject: Re: why schema name is same as username behaves different then ot