| Lists: | pgsql-novice |
|---|
| From: | "chakkara rangarajan" <ranga(at)dvdstation(dot)com> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | synonym and design tool |
| Date: | 2003-08-29 20:44:49 |
| Message-ID: | 200308292040.h7TKeWhs003819@microretail.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
Hi,
I am coming with an oracle background. In oracle, if user A wants to access
the objects of user B, User A has got 2 options:
1. Access the object using dot notation
2. Access the object after creating a synonym for the user B object in USER
A schema and access the object using the synonym.
Is there any equivalency in PGsql and if so, please let me know.
Also, please let me know, if there is any downloadable design tool(freeware)
available for the design of the schema?
Thx
--Ranga
| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | chakkara rangarajan <ranga(at)dvdstation(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: synonym and design tool |
| Date: | 2003-08-30 02:00:01 |
| Message-ID: | 20030830020001.GA30027@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
On Fri, Aug 29, 2003 at 13:44:49 -0700,
chakkara rangarajan <ranga(at)dvdstation(dot)com> wrote:
> Hi,
>
> I am coming with an oracle background. In oracle, if user A wants to access
> the objects of user B, User A has got 2 options:
>
> 1. Access the object using dot notation
>
> 2. Access the object after creating a synonym for the user B object in USER
> A schema and access the object using the synonym.
>
>
>
> Is there any equivalency in PGsql and if so, please let me know.
In 7.3 and above you can do option one using schemas.
There isn't any equivalent of synonyms.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | chakkara rangarajan <ranga(at)dvdstation(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: synonym and design tool |
| Date: | 2003-08-30 02:49:12 |
| Message-ID: | 19711.1062211752@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> In 7.3 and above you can do option one using schemas.
> There isn't any equivalent of synonyms.
... on the other hand, we have the notion of a schema search path,
which AFAIK doesn't exist in Oracle.
regards, tom lane
| From: | "chakkara rangarajan" <ranga(at)dvdstation(dot)com> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Bruno Wolff III'" <bruno(at)wolff(dot)to> |
| Cc: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | psql - interactive |
| Date: | 2003-09-08 19:38:53 |
| Message-ID: | 200309081934.h88JYZrl020265@microretail.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
Hi Postgres gurus,
Sorry for the cross-comparison once again with oracle.
In oracle query client(sqlplus), I can make a query generic and interactive
with the user by using '&' like:
Select column_name
From table_name
Where column_name='&user_input';
Can I achieve the same functionality in psql?
Also, please suggest me a good document source for the extensive commands of
psql
Thx
--Ranga