Re: Do we want SYNONYMS? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Do we want SYNONYMS?
Date
Msg-id 1291665747.20631.6639.camel@jd-desktop
Whole thread Raw
In response to Re: Do we want SYNONYMS?  (Andy Colson <andy@squeakycode.net>)
Responses Re: Do we want SYNONYMS?  (Michael C Rosenstein <mcr@mdibl.org>)
Re: Do we want SYNONYMS?  (Dmitriy Igrishin <dmitigr@gmail.com>)
Re: Do we want SYNONYMS?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, 2010-12-06 at 13:57 -0600, Andy Colson wrote:
> 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?

SYNONYMS work for things that aren't a table.

JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt


pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Do we want SYNONYMS?
Next
From: Michael C Rosenstein
Date:
Subject: Re: Do we want SYNONYMS?