Re: Do we want SYNONYMS?
| От | Dmitriy Igrishin |
|---|---|
| Тема | Re: Do we want SYNONYMS? |
| Дата | |
| Msg-id | AANLkTing=8HfTGgZz4gwvwbEm5s24_Nc181rURpKf1=L@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Do we want SYNONYMS? ("Joshua D. Drake" <jd@commandprompt.com>) |
| Список | pgsql-general |
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...
--
// Dmitriy.
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:SYNONYMS work for things that aren't a table.
> 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?
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.
В списке pgsql-general по дате отправления: