On Thursday 24 March 2005 08:35, Lee Wu wrote: > I believe you're right. > > Any easy way to find out if -d was used if dump is done someone else?
yes, just look into your dump file. If it contains INSERT statements -d was used, if it contains COPY statement -d was not used. > > Thanks, > > -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 24, 2005 9:11 AM > To: Lee Wu > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] pg_dump, pg_restore, insert vs copy > > "Lee Wu" <[EMAIL PROTECTED]> writes: > > MY OS command is: > > pg_restore -v -t mytable -d mydb -U postgres -R my.dmp > > That doesn't prove a thing; the question is what you typed at pg_dump. > > Thinking about it, I wonder if you did "pg_dump -d mydb ..." > -d means something different to pg_dump than pg_restore. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
