MS Access to PostgreSQL Types Mapping |
| [MS Access to PostgreSQL Converter] [Troubleshooting] [Tutorial] |
MS Access and PostgreSQL have similar set of data types. Some of them are match each other while others are not. When planning MS Access to PostgreSQL migration, it is important to know safe types mapping for the two DBMS. The table below contains safe mapping for all MS Access data types.
| MS Access | PostgreSQL |
| Text | Varchar(255) |
| Memo | Text |
| Byte | Smallint |
| GUID | Uuid |
| Integer | Smallint |
| Long | Integer |
| Single | Real |
| Double | Float |
| Money (Currency) | Numeric(19,4) |
| Auto Number | Serial |
| Date/Time | Timestamp |
| Yes/No | Boolean |
| Ole Object | Bytea |
| Hyperlink | Text |