Forum OpenACS Q&A: Re: Postgres 7.2.3 Data to Oracle 8.1.7

Posted by Andrei Popov on
Wouldn't a result of pg_dump (with --inserts --no-owner and --no-priveleges) almost work?  It should be just an SQL script with all the CREATE statements and INSERTs for data.

Granted, CREATEs are not going to be perfect -- some tweaking may be required.