> Actually, the database db2 has all ready been created, plus the table names
> are the same, so I can not use pg_dump and restore.
Sure you can:
dropdb db2
createdb db2 ...
> >pg_dump -d db1 -t table1 |psql db2
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346