[SQL] Table Copy.

[PostgreSQL Server]

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




---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]