More

Problem using ogr2ogr to convert postGIS table to personal geodatabase


I need to convert a PostGIS table to a personal geodatabase using ogr2ogr. I can convert tables to a shapefile without a problem but whenever I try to convert it to .mdb using the ODBC driver, I get an error. I have got the 64-bit GDAL version and also the 64-bit ODBC driver installed.

This is my command:

ogr2ogr -f "ODBC" C:users[user]file.mdb PG:"host=localhost user=[user] dbname=[db] password=[password]" "[tablename]"

This is the error I get:

ODBC driver failed to create C:users[user]file.mdb

Am I using the right command to do this, or am I missing a driver or something?


Per the docs:

Currently the ODBC OGR driver is read-only, so new features, tables and datasources cannot normally be created by OGR applications.

Additionally, neither the PGeo nor MDB drivers support creation.


Watch the video: - Load raster into PostGIS - with DB Manager - View in QGIS (October 2021).