Look up pg_dump and pg_dumpall in the manual. There is a way to tell
postgresql to make the output as if you were to retype it in psql
yourself (i.e. it does CREATE TABLE, INSERT INTO, etc.). It takes
longer for it to generate the file but it may clear up those
inconsistencies.
--
Daniel R. Anderson
Chief Lab Rat and Helper Monkey
Great Lakes Industries, Inc.
80 Pineview Ave.
Buffalo, NY 14218
(716) 691-5900 x218
"Never let your schooling interfere with your education"
-- Mark Twain