restore_db
Posted: Tue Sep 13, 2011 6:05 am
hi!
I am writing an method to restore the database tables. my input is a zip file that contains the data(insert scripts). I am not allowed to use pgAdmin. What is the best approach insert these data in the database and synchronize the sequences?
e.g.
table:address
column:
idaddress (servoy_seq)
street
city
script to execeute:
INSERT INTO address (idaddress, street, city) VALUES (8, '2 Rawson Street', 'Sydney');
where 8 is from the idaddress when the backup was performed.
I am writing an method to restore the database tables. my input is a zip file that contains the data(insert scripts). I am not allowed to use pgAdmin. What is the best approach insert these data in the database and synchronize the sequences?
e.g.
table:address
column:
idaddress (servoy_seq)
street
city
script to execeute:
INSERT INTO address (idaddress, street, city) VALUES (8, '2 Rawson Street', 'Sydney');
where 8 is from the idaddress when the backup was performed.