Re: A table with two names or table alias

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 name to table CITY, like LOCATION, to make 
> possible these two sentences:
> 
>       insert into CITY values (10, 'New York');
>       insert into LOCATION values (11, 'Paris')
> 
>    Thank you.

You can create a VIEW, and if you want to insert data into the view, you
can create rules for that.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net