On Wed, Dec 1, 2010 at 3:55 PM, Alvaro Herrera
> Excerpts from Josh Berkus's message of mié dic 01 17:13:35 -0300 2010:
>> > Well, porting applications from other database systems that support synonyms
>> > (i.e. Oracle, DB2, SQL Server).
>> SQL Server supports synonyms? If it's not Oracle-only, it's a more
>> powerful argument to have the feature.
> I think it's worth mentioning that in SQL Server, synonyms are not
> schema-qualified; they're "global" objects.
Seems like they have more than one kind.
The section entitled "notes on public synonyms" is particularly
interesting, as it seems to imply that under some but not all
conditions synonyms get materialized inside schemas that use them.
The list of objects for which they support synonyms is also
The Enterprise PostgreSQL Company
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2010-12-02 20:43:50|
|Subject: Re: Another proposal for table synonyms|
|Previous:||From: Heikki Linnakangas||Date: 2010-12-02 19:52:27|
|Subject: Re: directory archive format for pg_dump|