But why shadow happens only schema name is SAME as username?? Jie
-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:58 PM To: Jie Liang Cc: 'Bruce Momjian'; [EMAIL PROTECTED] Subject: Re: why schema name is same as username behaves different then others Jie Liang <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
