Re: [SQL] restoring a dump

2001-06-28 Thread Wei Weng
Do not understand your question. On 28 Jun 2001 16:32:47 -0700, Phuong Ma wrote: > I tried using pg_restore, but it did not restore the dump successfully. > Maybe it is the syntax I'm using, but I remember reading that you cannot > use the pg_restore to restore a dump that uses INSERT. Does an

Re: [SQL] restoring a dump

2001-06-28 Thread Phuong Ma
Peter Eisentraut wrote: > > Phuong Ma writes: > > > pg_dump -C -D -F t > test.tar > > tar -xvf test.tar > > psql restore.sql > > psql test < 19.dat > > psql test < 20.dat .. and so on > > psql test < toc.dat > > I believe you're supposed to use pg_restore on the tar file itself. > > -- > Peter