> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to