Grr, deleted Tom's email before I replied...
pg_dump -Fc | pg_restore will only match the output of pg_dump if
everything's the same version though, right? Or wrong? What happens if
pg_dump -Fc is and older version and pg_restore is the current version?
Or is the custom format the same as the text/SQL dump, just with some
fancy wrappers around it?
--
Jim C. Nasby, Database Architect [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
