In article <[EMAIL PROTECTED]>, Chris Campbell <[EMAIL PROTECTED]> writes:
> Harald Fuchs wrote: >> Why don't you just do >> ( echo "-- This is my comment" >> pg_dump whatever >> ) > dumpfile >> ? > How could I dump using the custom format, and then use "dumpfile" with > pg_restore to restore the dump? If I just prepend the comment to the > file, then pg_restore will choke, since the file won't be in the > proper custom format. I would have to remove the comment before > sending the file to pg_restore. Is there an easy way to do that? That > can be easily automated, and not take a huge amount of time given a 4 > gig dump file that must be modified? Since pg_restore is able to read from standard input, that should not be a problem: instead of pg_restore options dumpfile just do sed 1d dumpfile | pg_restore options ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings