Postgres Pro
Downloads
Home   >   mailing lists

Re: Another proposal for table synonyms - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Another proposal for table synonyms
Date
Msg-id 1291236848-sup-7816@alvh.no-ip.org
Whole thread Raw
In response to Re: Another proposal for table synonyms  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Another proposal for table synonyms  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Another proposal for table synonyms
Next
From: Robert Haas
Date:
Subject: Re: crash-safe visibility map, take three