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.
In MDB Viewer:
In pgAdmin:
After the query has finished, your tables will show up in the "public" schema.
PostgreSQL supports similar column types as MS Access, but they use different names.
Access Type | PostgreSQL Type |
---|---|
Boolean | BOOLEAN |
Byte | INTEGER |
Integer | INTEGER |
Long Integer | INTEGER |
GUID | TEXT |
Decimal | DOUBLE PRECISION |
Money | DOUBLE PRECISION |
Float | DOUBLE PRECISION |
Double | DOUBLE PRECISION |
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)