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@commandprompt.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
--
// Dmitriy.