Table Copy. - Mailing list pgsql-sql

From PostgreSQL Server
Subject Table Copy.
Date
Msg-id Pine.LNX.4.44.0209191747250.31615-100000@sunrise2.radiostudiodelta.it
Whole thread Raw
Responses Re: Table Copy.  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List 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





pgsql-sql by date:

Previous
From: Mathieu Arnold
Date:
Subject: Re: Stripping white-space in SELECT statments
Next
From: Tom Lane
Date:
Subject: Re: How To Get Bytea Data Instead Of Its Oid