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.