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