Select Code to Download

create table foo;
create table foo (id text, name varchar(15));
...
insert into backupfoo (select * from foo);
delete from foo; -- you would obviously use a WHERE clause to restrict
+ what you are deleting
>>> 3 records copied

pg_dump -d  YOURDATABASE -t backupfoo > mybackup.sql

psql -d YOURDATABASEARCHIVE -f mybackup.sql