Thread: Questions about Synonyms - Again
Hi, Quick questions, I hope! Are Synonyms supported on Postgresql? If so, how can I list them? Also, If so, what version did they began to be supported? Thanks, Colin
Colin Taylor writes: > Are Synonyms supported on Postgresql? There is nothing in PostgreSQL that's called a "synonym" per se, so you have to describe what you mean by it. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
I am comparing it to Oracle's public synonyms, where you can use different names for things. For example, table "THIS_IS_A_VERY_BYG_NAME" could be accessed using a smaller name, example "TIAVBN". > -----Original Message----- > From: Peter Eisentraut [mailto:peter_e@gmx.net] > Sent: Friday, January 19, 2001 3:56 PM > To: Colin Taylor > Cc: Pgsql Mailing List (E-mail) > Subject: Re: [GENERAL] Questions about Synonyms - Again > > > Colin Taylor writes: > > > Are Synonyms supported on Postgresql? > > There is nothing in PostgreSQL that's called a "synonym" per > se, so you > have to describe what you mean by it. > > -- > Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/ >
Oracle's synonyms have uses which extend from that. To wit, we use, in our production model, three different schemas. The BATCH schema has the high throughput tables, the ONLINE schema has the reference data tables (lower throughput), and the REPORT schema has only some configuration tables. However, each schema can see the tables defined in the other schemas without having to explicitly reference the schema, i.e.: if you were connected to the REPORT schema, and wanted to to select from a table called ORG you would have to:
select * from ONLINE.ORG;
If there was a public synonym (or a private synonym in the REPORT schema) for ORG, then, if you were connected to the REPORT schema, you could just:
select * from ORG;
Postgres has no concept of schemas, but it might be useful to do the same thing between different databases, i.e.: the schemas are implemented by PG databases. Then you could select across databases. Exactly why you would want to do this is another story, which I'm not going to go into. I'm sure that there are administrators and db designers out there who could provide more reasons than I could. I'm just a lowly developer.
Cheers...
MikeA
-----Original Message-----
From: Colin Taylor [mailto:Colin_Taylor@PortaSystemsDev.com]
Sent: 19 January 2001 15:53
To: 'Peter Eisentraut'
Cc: Pgsql Mailing List (E-mail)
Subject: RE: [GENERAL] Questions about Synonyms - Again
I am comparing it to Oracle's public synonyms, where you can use different
names for things.
For example, table "THIS_IS_A_VERY_BYG_NAME" could be accessed using a
smaller name, example "TIAVBN".
> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e@gmx.net]
> Sent: Friday, January 19, 2001 3:56 PM
> To: Colin Taylor
> Cc: Pgsql Mailing List (E-mail)
> Subject: Re: [GENERAL] Questions about Synonyms - Again
>
>
> Colin Taylor writes:
>
> > Are Synonyms supported on Postgresql?
>
> There is nothing in PostgreSQL that's called a "synonym" per
> se, so you
> have to describe what you mean by it.
>
> --
> Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
>
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
Nick West - Global Infrastructure Manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
Do we want to add this to the TODO list? [ Charset ISO-8859-1 unsupported, converting... ] > I am comparing it to Oracle's public synonyms, where you can use different > names for things. > For example, table "THIS_IS_A_VERY_BYG_NAME" could be accessed using a > smaller name, example "TIAVBN". > > > -----Original Message----- > > From: Peter Eisentraut [mailto:peter_e@gmx.net] > > Sent: Friday, January 19, 2001 3:56 PM > > To: Colin Taylor > > Cc: Pgsql Mailing List (E-mail) > > Subject: Re: [GENERAL] Questions about Synonyms - Again > > > > > > Colin Taylor writes: > > > > > Are Synonyms supported on Postgresql? > > > > There is nothing in PostgreSQL that's called a "synonym" per > > se, so you > > have to describe what you mean by it. > > > > -- > > Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/ > > > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
I think this should wait till proper schema support is implemented. Most frequent use of synonym is to create a public alias to a object in a private schema. -alex On Fri, 19 Jan 2001, Bruce Momjian wrote: > > Do we want to add this to the TODO list? > > [ Charset ISO-8859-1 unsupported, converting... ] > > I am comparing it to Oracle's public synonyms, where you can use different > > names for things. > > For example, table "THIS_IS_A_VERY_BYG_NAME" could be accessed using a > > smaller name, example "TIAVBN". > > > > > -----Original Message----- > > > From: Peter Eisentraut [mailto:peter_e@gmx.net] > > > Sent: Friday, January 19, 2001 3:56 PM > > > To: Colin Taylor > > > Cc: Pgsql Mailing List (E-mail) > > > Subject: Re: [GENERAL] Questions about Synonyms - Again > > > > > > > > > Colin Taylor writes: > > > > > > > Are Synonyms supported on Postgresql? > > > > > > There is nothing in PostgreSQL that's called a "synonym" per > > > se, so you > > > have to describe what you mean by it. > > > > > > -- > > > Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/ > > > > > > > >