Re: Do we want SYNONYMS? - Mailing list pgsql-general

From Tom Lane
Subject Re: Do we want SYNONYMS?
Date
Msg-id 2186.1291669744@sss.pgh.pa.us
Whole thread Raw
In response to Re: Do we want SYNONYMS?  (Michael C Rosenstein <mcr@mdibl.org>)
Responses Re: Do we want SYNONYMS?  (Michael C Rosenstein <mcr@mdibl.org>)
Re: Do we want SYNONYMS?  ("Mark Felder" <feld@feld.me>)
List pgsql-general
Michael C Rosenstein <mcr@mdibl.org> writes:
>> What is "schema" in this context?

> Oracle "schema" == Postgres "database":  a collection of objects
> (tables, functions, triggers, views, etc) owned by a user.

That seems like a pretty unlikely equivalence.  What I'm afraid
you are really saying you want is cross-database synonyms (ie links
to objects in remote databases).  Which I'm pretty sure is not what
JD is offering to implement, though I think it is possible to do
in Oracle.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Do we want SYNONYMS?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: Do we want SYNONYMS?