On Fri, 27 Feb 2004 20:14:53 +0100, Jean-Michel Chabanne
<[EMAIL PROTECTED]> wrote:
Le ven 27/02/2004 ×ï 03:40, Tsirkin Evgeny a ×âcrit :
Hi all!
I have the following task :
I have some tables edited (insert/update) by users.
I should create a file (in whatever format) containing
changes of the last day,every day.What I have currently
is :
I have two tables of the same structer ,every day i :
select * from newtable
except
select * from oldtable
And then format the data with perl script.After that ,i
am copying the data from the new table to the old table .It
works pretty good except that the copying is VERY slow:
I use :
insert into old from (select * from newtable);
Is there any more afficient way to do what i need ,
that somebody already use?
Is there any more afficient way to copy data between
tables?
I know that i can use COPY to copy files from
and to files ,can it be used here?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
If I had to do this, I would use triggers which, on every INSERT/UPDATE
by users, would insert the new item + timestamp or date in a new table.
I hope this will help you.
That would not make me able to know WHAT was the change:
what was there befor and after the update
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
