Duplicating a table with a trigger

Поиск
Список
Период
Сортировка
От Wayne Oliver
Тема Duplicating a table with a trigger
Дата
Msg-id 467399C8-A476-45A7-A0AC-5B64C13C31B1@gmail.com
обсуждение исходный текст
Ответы Re: Duplicating a table with a trigger  (Luca Ferrari <fluca1978@infinito.it>)
Список 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



Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: DrYSG
Дата:
Сообщение: PostGreSQL and NodeJS
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: Duplicating a table with a trigger