On Mon, Sep 17, 2012 at 7:06 PM, Adam Mackler <adammackler@xxxxxxxxx> 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 > view? I don't think so, as I've wanted something similar myself. The easiest way I found is to create two views, in the same schemas as their corresponding tables. It's double maintenance but it's cheap to run. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
