ruben <[EMAIL PROTECTED]> writes:
> I'm trying to dump tableA and restore it to tableB:
pg_dump does not do that. The -t switch is for selecting one table
among several, not for renaming anything.
regards, tom lane
---(end of broadcast)---
Hi:
I'm trying to dump tableA and restore it to tableB:
$ ./pg_dump -Fc -t tableA databaseA -f tableA.dump -v
$ ./pg_restore -t tableB -d databaseA tableA.dump -v
pg_dump creates tableA.dump aparently well, but after running pg_restore
without errors I cannot find any "tableB", what am I doing wro