> pg_dump -c -t <table name> <database> > <dumpfile> > psql <database> < <dumpfile> I don't tested this but i think this works. Be dangerous with the "-c" Option of dump ;). After the dump was created, new data could be inserted into the database. If you dump in the file, all dumped tables are dropped. It's better to RENAME the existing table and then COPY in the data. greetings, Martin Am Dienstag, den 28.06.2005, 13:26 -0400 schrieb Chuming Chen: > pgsql-admin@xxxxxxxxxxxxxx
