MDB Viewer Download Buy Now Also available on the
Mac App Store

MDB Viewer requires OS X 10.6 or later. The free trial is fully functional except for export limitations.
© 2011-2017 Jakob Egger

Help Index

Migrating Access Databases to PostgreSQL

MDB Viewer supports exporting tables to SQL dumps that are compatible with PostgreSQL. To upload the data to a server you must execute the SQL dump with a separate application, for example using pgAdmin. pgAdmin is a free PostgreSQL client application.

For general information about SQL files, see Exporting as SQL.

Migrating Step by Step (using pgAdmin)

In MDB Viewer:

Postgres Export Options

In pgAdmin:

After the query has finished, your tables will show up in the "public" schema.

Access Types vs. PostgreSQL Types

PostgreSQL supports similar column types as MS Access, but they use different names.

Access TypePostgreSQL Type
Boolean BOOLEAN
Byte INTEGER
Integer INTEGER
Long Integer INTEGER
GUID TEXT
Decimal DOUBLE
Money DOUBLE
Float DOUBLE
Double DOUBLE
Date/Time TIMESTAMP
Text TEXT
Memo TEXT
Ole BYTEA

To prevent compatibility issues, strings are quoted using escape string constants. (see Section 4.1.2.2 of the PostgreSQL documentation)

Help Index

Questions? Contact Jakob Egger.