| From: | PostgreSQL Server <postgres(at)rsd(dot)it> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Table Copy. |
| Date: | 2002-09-19 15:56:04 |
| Message-ID: | Pine.LNX.4.44.0209191747250.31615-100000@sunrise2.radiostudiodelta.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
HI!
I'm new to postgres. I need to have a table as a copy of another one.
Example:
CREATE TABLE one (
fileda INTEGER,
filedb INTEGER,
filedc INTEGER );
CREATE TABLE two (
fileda INTEGER,
filedb INTEGER,
filedc INTEGER );
As on insert to table one I should get the same insert on table two.
As on delete to table one I should get the same delete on table two.
As on update to table one I should get the same update on table two.
Can someone provide the examples i can study ?
Thanks in advance.
Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-19 16:46:38 | Re: How To Get Bytea Data Instead Of Its Oid |
| Previous Message | Mathieu Arnold | 2002-09-19 14:41:23 | Re: Stripping white-space in SELECT statments |