I believe you're right. Any easy way to find out if -d was used if dump is done someone else?
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
