Re: posible BUG on psql... or maybe worst - Mailing list pgsql-general

From Bruce Momjian
Subject Re: posible BUG on psql... or maybe worst
Date
Msg-id 200812061944.mB6JiHa23259@momjian.us
Whole thread Raw
In response to Re: posible BUG on psql... or maybe worst  ("Diego Schulz" <dschulz@gmail.com>)
Responses Want quit milis
List pgsql-general
Diego Schulz wrote:
> > Sorry, forgot to say that I SET search_path acordinlly to see relations
> > from both schemas. But whan the table has the same name I only get the one
> > from the first schema in the search_path.
> >
>
>
> I can confirm the behaviour you described.

Yes, \dt was designed that way, and *.name is the proper way to show
tables in all schemas.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: Sebastian Tennant
Date:
Subject: Re: Resp.: Automatic insert statement generator?
Next
From: Glyn Astill
Date:
Subject: Re: Planner picking topsey turvey plan?