Postgres Pro
Downloads
Home   >   mailing lists

Thread: synonym and design tool

synonym and design tool

From
"chakkara rangarajan"
Date:

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

Re: synonym and design tool

From
Bruno Wolff III
Date:
On Fri, Aug 29, 2003 at 13:44:49 -0700,
  chakkara rangarajan <ranga@dvdstation.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.

Re: synonym and design tool

From
Tom Lane
Date:
Bruno Wolff III <bruno@wolff.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

psql - interactive

From
"chakkara rangarajan"
Date:
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