Opened 12 years ago
Closed 12 years ago
#4722 closed defect (worksforme)
FGDB and non-spatial data
| Reported by: | aestrada | Owned by: | warmerdam |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | default | Version: | unspecified |
| Severity: | normal | Keywords: | FGDB |
| Cc: |
Description
Is there a way to export non spatial tables from a DB(postgresql) to FGDB? It appears to always be looking for a geometry column. If this is the intended behavior, this is obviously not an issue.
Change History (4)
comment:1 by , 12 years ago
comment:2 by , 12 years ago
ogr2ogr -skipfailures -progress -update -append -f "FileGDB" %FGDB_NAME%.gdb PG:%POSTGRESQL% -sql "SELECT * FROM nospatialtable" -nln "Booya" --config FGDB_BULK_LOAD yes
That is the command line I am following and I get the error stating that the FGDB driver can't find the GEOM column.
comment:3 by , 12 years ago
I cannot reproduce any issue with a similar command. What is the exact error message, but more importantly I suspect this may be the name of a column in your nospatialtable. Perhaps you could paste the output of : ogrinfo -so PG:%POSTGRESQL% -sql "SELECT * FROM nospatialtable"
comment:4 by , 12 years ago
| Resolution: | → worksforme |
|---|---|
| Status: | new → closed |
No feedback from reporter. Closing. Reopen if you can provide more information
Is your problem that you cannot list non-spatial table from a postgres DB ? If so, you must be aware that you have to define the PG_LIST_ALL_TABLES=YES configuration option. See http://gdal.org/ogr/drv_pg_advanced.html .