2010/12/7 Dmitriy Igrishin <dmit...@gmail.com> > > > 2010/12/7 Gauthier, Dave <dave.gauth...@intel.com> > > 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. >> > Interesting, how will you maintain synonyms in a many databases ? > IMO it is more simple to make abstraction level at the application side > in one place rather than create synonyms in different databases. > And if you just standardize the naming in a different databases why not use views ?
> > >> >> -----Original Message----- >> From: pgsql-general-ow...@postgresql.org [mailto: >> pgsql-general-ow...@postgresql.org] On Behalf Of Andy Colson >> Sent: Monday, December 06, 2010 2:57 PM >> To: j...@commandprompt.com >> Cc: pgsql-general@postgresql.org >> Subject: Re: [GENERAL] 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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > > > > -- > // Dmitriy. > > > -- // Dmitriy.
