So basically I imported .gdb package into PostgreSQL with the following command:
ogr2ogr -f "PostgreSQL" PG:"dbname='my_database'" "ntest.gdb" "layername" -nln table_layername
I have about 50+ layers in one GDB, so I run this script for all 50+ layers. After all the tables have been edited/processed, I have to dump all my 50+ tables into one .gdb again. I have tried as suggested here
ogr2ogr -f "FileGDB" errors.gdb PG:"dbname='my_database' tables='table_layername, table_layername2, etc'"
But this gives me errors:
ERROR 1: PQconnectdb failed. missing "=" after "table_layername2," in connection info string
If I run the same command without tables part in PG, but specifying the table in the end it gives me:
ERROR 1: Unable to find driver `FileGDB'.
If I try the existing driver "OpenFileGDB", the error is:
ERROR 1: OpenFileGDB driver does not support data source creation.
I guess it is because OpenFileGDB is only read-only, whereas FileGDB is read and write access (source).
All the information I am finding is old (2012-2015)6 so my question is:
- Where to find and how to install the `FileGDB' driver? Does it still exist?
- If I could install it, how can dump all my tables into one .gdb file? Will my command work if the driver is installed?
Edit: My Operating System: Debian GNU/Linux 9 (stretch); Kernel: Linux 4.9.0-8-amd64; Architecture: x86-64;