I have the feeling the answer is no, but I would like an authoritative
answer before I give up.
My plan was to have two schemas: one for the live data, and one for
staging, training, and testing. Both schemas would have identically-named
tables. I wanted to create a single view in the public
Adam Mackler, 17.09.2012 11:06:
I have the feeling the answer is no, but I would like an
authoritative answer before I give up.
My plan was to have two schemas: one for the live data, and one for
staging, training, and testing. Both schemas would have
identically-named tables. I wanted to
On Mon, Sep 17, 2012 at 7:06 PM, Adam Mackler adammack...@gmail.com wrote:
Am I correct in concluding that there's no way to have a single view in the
public schema that selects data from tables in different other schemas
depending on my search_path at the time I execute a query involving that
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Chris Angelico
Sent: Monday, September 17, 2012 9:12 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Can a view use a schema search_path?
On Mon, Sep
On 17 September 2012 11:06, Adam Mackler adammack...@gmail.com wrote:
I have the feeling the answer is no, but I would like an authoritative
answer before I give up.
My plan was to have two schemas: one for the live data, and one for staging,
training, and testing. Both schemas would have
dangerous
Regards
From: Alban Hertroys haram...@gmail.com
To: Adam Mackler adammack...@gmail.com
Cc: pgsql-general@postgresql.org
Sent: Monday, September 17, 2012 4:46 PM
Subject: Re: [GENERAL] Can a view use a schema search_path?
On 17 September 2012 11:06