Opened 11 years ago
Closed 5 years ago
#5250 closed task (wontfix)
Reading non-spatial Access tables with ogr2ogr
| Reported by: | as | Owned by: | warmerdam |
|---|---|---|---|
| Priority: | normal | Milestone: | closed_because_of_github_migration |
| Component: | default | Version: | 1.9.1 |
| Severity: | normal | Keywords: | |
| Cc: |
Description
Hi all,
I am trying to read a whole Access database into Postgis using the ogr2ogr (Version 1.9.1) command.
For some reason however, it only reads spatial tables and no non-spatial tables. All my attempts to overcome this problem so far have failed and I could find no useful information on the Internet.
I have tried configuring options such as -nlt None SET PG_LIST_ALL_TABLES=YES
How is it possible to read ALL tables and not only the spatial tables?
This is the command I've used:
ogr2ogr --config PG_LIST_ALL_TABLES YES -f "PostgreSQL" PG:"host=localhost user=postgres dbname=ele_schnottwil password=bsb port=5432" C:\ele.mdb -a_srs EPSG:21781 -overwrite -skipfailures
I know PG_LIST_ALL_TABLES is a Postgis driver command but I read this could be used for the ODBC driver, too.
Can anyone see the problem or help me out.
Thanks so much in advance.
Best regards, Arne
Change History (1)
comment:1 by , 5 years ago
| Milestone: | → closed_because_of_github_migration |
|---|---|
| Resolution: | → wontfix |
| Status: | new → closed |
This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to https://github.com/OSGeo/gdal/issues if it is not already reported there.