| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Marc Lavergne <mlavergne-pub(at)richlava(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: CREATE SYNONYM suggestions |
| Date: | 2002-07-25 21:16:10 |
| Message-ID: | 1027631770.1915.7.camel@rh72.home.ee |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 2002-07-26 at 02:54, Marc Lavergne wrote:
> Like you said, it's really just a symlink for db objects. If memory
> serves me right, synonyms can only refer to tables and views in Oracle.
> The most common use is for simplifying access to objects outside your
> schema (eg. create synonym TABLEX for JOHN.TABLEX) or for simplifying
> access to objects across database links (eg. create synonym TABLEX for
> TABLEX(at)DBY).
For quick answers on SYNONYM use in DB2 see
http://members.aol.com/cronid/db2.htm
(search for synonym)
I found no SYNONYM in SQL99 but for a similar construct ALIAS, there is
a reserved word in SQL99, but I could find no definition using it.
----------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Lavergne | 2002-07-25 21:54:22 | Re: CREATE SYNONYM suggestions |
| Previous Message | Mike Mascari | 2002-07-25 21:00:32 | Re: tuple concurrently updated |