You could always cheat and export the data to something along the lines of a CSV file. You'd have to re-create the tables manually, but then you could import the data.
If you're proficient with PERL-DBI you could script the process as well. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Davis Sent: Tuesday, March 23, 2004 2:58 PM To: [EMAIL PROTECTED] Subject: [RLUG] PostgreSQL 7.x downgrade Has anybody successfully downgraded a postgres database's data, say from 7.4 to 7.3 or 7.3 to 7.2 etc? I'm trying to get data from a 7.4.2 database, using pg_dump, into a 7.3.4 database on another server (via psql). It seems like the 7.4.x sql syntax to create SEQUENCES seems have changed and, of course, fails on restore. There doesn't seem to be anything like '--dump-version=' on the pg_dump man page. -- David Davis _______________________________________________ RLUG mailing list [EMAIL PROTECTED] http://www.rlug.org/mailman/listinfo/rlug _______________________________________________ RLUG mailing list [EMAIL PROTECTED] http://www.rlug.org/mailman/listinfo/rlug
