Search Postgresql Archives

Re: Do we want SYNONYMS?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I think aliasing non-table/view was mixed by Tom, but just as FYI, aliasing column names would be very helpful in my apps. Aliasing "last_name", "lastname", "surname" together in a people table for example.  We have many design sites that have identical data concepts but with different names for the same thing.  It would be nice to just equate these names in the DB instead of in perl wrappers around sql calls.
 

-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Andy Colson
Sent: Monday, December 06, 2010 2:57 PM
To: jd@xxxxxxxxxxxxxxxxx
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  Do we want SYNONYMS?

On 12/6/2010 1:31 PM, Joshua D. Drake wrote:
> Hey -general,
>
> Command Prompt is currently considering writing a patch to provide
> synonyms to PostgreSQL. Is this something the community is interested
> in? Do we have use cases for it? MSSQL, DB2 and Oracle support them.
>
> Reference thread:
>
> http://archives.postgresql.org/pgsql-hackers/2010-11/msg02043.php
>
> Joshua D. Drake

I dont understand the need for it.  Dont view's do the exact same thing 
(plus even more)?  What does a synonym offer that a view does not?

And perusing the thread, I see it might cause all name and operator 
lookups to be slower?  (I didnt read all of it though)

I'm gonna have to go:  -1

-Andy

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux