Re: [GENERAL] pg_restore does not restore

2004-10-25 Thread Tom Lane
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)---

[GENERAL] pg_restore does not restore

2004-10-25 Thread ruben
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