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