Thread: pg_dump from 7.3 to 7.2

Hi!

A database dump (plain text version) generated on postgresql 7.3
contains explicit schema names (public.) in drop and create statements,
which makes it difficult to load such a dump into 7.2 (one can edit the
file and remove all 'public.' strings, but that's not an ideal
solution).

Is there a good method for performing such a migration?

Richard.

--
** Internet Designers S.A., ul. Przedmiejska 6-10, 54-201 Wrocław **
 tel. (071) 35 00 445 w. 25; fax (071) 37 35 946; http://www.id.pl/

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