Duplicating a table with a trigger - Mailing list pgsql-novice

From Wayne Oliver
Subject Duplicating a table with a trigger
Date
Msg-id 467399C8-A476-45A7-A0AC-5B64C13C31B1@gmail.com
Whole thread Raw
Responses Re: Duplicating a table with a trigger
List pgsql-novice
Hi All,

I was hoping somebody here could point me in the right direction.
I am trying to duplicate changes to a specific table to a copy of that table.

Does that make sense?

basically I have

my_awesome_table

and

my_awesome_table_copy

Every time there is an insert or an update on my_awesome_table I would like to run exactly the same update or insert on
my_awesome_table_copy.
I was thinking a trigger but the how to there after has got me a little confused.

if anyone could help it would be greatly appreciated.

Thanks
Wayn0



Attachment

pgsql-novice by date:

Previous
From: DrYSG
Date:
Subject: PostGreSQL and NodeJS
Next
From: Luca Ferrari
Date:
Subject: Re: Duplicating a table with a trigger