Re: Do we want SYNONYMS?

Hey Michael,

2010/12/6 Michael C Rosenstein <mcr(at)mdibl(dot)org>

> Synonyms would be very helpful to us. We just migrated our application from
> Oracle, where we used synonyms to toggle between between two schemas: one
> schema could be loaded with new data, while synonyms pointed the web
> application to the live schema. Once the data load was done, we switched the
> web app's synonyms to switch to the new live schema.
>
Interesting. What is "schema" in this context?

>
> We've hacked a solution in Postgres using search paths, but search paths
> don't work as well as synonyms when the target objects are not in the same
> schema ("database" in PG-ese, I think).
>
> /mcr
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
// Dmitriy.