Good morning, I've recently just inherited a PostgreSQL database that is a back end for some logistics software we use here. We have our own Oracle servers in our group on faster machines with automated backup so we would like to move all the data over to Oracle. The software came with scripts to create the owners, tables and permissions in Oracle but when using "pgAdmin" (Windows client being used to administer the PostgreSQL database at the moment) export feature which dumps the entire database in form of insert statements, seems to not carry over everything we need (lots of data is missing from the application). Can anyone recommend a clear cut way to migrate the data over? We're generating and importing a text file with almost a gig worth of import statements but we're figuring there has to be a easier way that will not only bring over all the data but do it more effeciently as well. Thanks
