Full Convert allows easy copying of tables and data between 40 or so supported databases. It will create all the tables, copy all of your data, then create indexes and foreign keys. It has powerful mapping and customization features and uses optimal copying mode for each table separately to achieve the best possible throughput.
Import into PostgreSQL from any of the source databases has been highly optimized, while keeping memory consumption extremely low. Typical conversion from almost any source database into local PostgreSQL target is in low hundreds of thousands of records per second with under 200MB of RAM usage. We support almost all Postgres data types, including spatial types.
For more information, please visit the product page: Full Convert.