Home > mailing lists

synonym and design tool - Mailing list pgsql-novice

From	chakkara rangarajan
Subject	synonym and design tool
Date	August 30, 2003 00:43:08
Msg-id	200308292040.h7TKeWhs003819@microretail.net Whole thread Raw
Responses	Re: synonym and design tool
List	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: Nabil Sayegh
Date: 29 August 2003, 15:22:15
Subject: "PostgreSQL now has working, tested, scalable replication!"

From: "Herbie McDuck"
Date: 30 August 2003, 00:45:22
Subject: Re: Boolean variables...