Re: Do we want SYNONYMS?

What is synonym? Is it a reference? Can I dump DDL of the object
by synonym? If no, I personally don't see how it can be used.
Maybe it can be used to create 7 synonyms for some table and let
application use different synonym depends on day of the week... :-)
I don't see how it can be used...

2010/12/6 Joshua D. Drake <jd(at)commandprompt(dot)com>

> 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
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
// Dmitriy.