Re: Do we want SYNONYMS?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael C Rosenstein <mcr(at)mdibl(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Do we want SYNONYMS?
Date: 2010-12-06 21:09:04
Message-ID: 2186.1291669744@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael C Rosenstein <mcr(at)mdibl(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2010-12-06 21:10:14 Re: Do we want SYNONYMS?
Previous Message BRUSSER Michael 2010-12-06 21:04:44 Database encoding and locale