There are no synonyms in Postgres (like in Oracle).
To implement what you want, you need to use views and rules.
From Postgres docs:
"Currently, views are read only: the system will not allow an insert,
update, or delete on a view. You can get the effect of an updatable view
by creating rules that
am Fri, dem 25.07.2008, um 14:12:47 +0200 mailte Tk421 folgendes:
>Can I create a table name alias?
>
>What i want is to access the same table with two different names. An
> example:
>
>I've the table CITY with fields code and name. I want to know if i
> can create an alternative n