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 <j...@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 > -- > 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- // Dmitriy.