Opened 17 years ago
Closed 16 years ago
#1699 closed enhancement (fixed)
postgres: add the ability to specify a list of tables to be treated as layers
Reported by: | cph | Owned by: | Even Rouault |
---|---|---|---|
Priority: | normal | Milestone: | 1.6.0 |
Component: | OGR_SF | Version: | unspecified |
Severity: | normal | Keywords: | postgis postgresql |
Cc: | warmerdam, project10, Mateusz Łoskot |
Description
This functionality is already available for other datasources(as per FrankW). This feature is really needed as it is a huge performance problem when we only want to export 1 table from a system with 100's of tables listed in the geometry_columns table.
Attachments (1)
Change History (7)
comment:1 by , 17 years ago
Cc: | added |
---|---|
Component: | default → OGR_SF |
Keywords: | postgis postgresql added |
Milestone: | → 1.5.0 |
Owner: | changed from | to
comment:2 by , 16 years ago
This patch allows the list of tables to be specified in the manner Frank suggests. Doing so skips enumeration of the spatial tables from the database metadata.
Includes documentation update and minor documentation style and grammar issue fixes.
comment:3 by , 16 years ago
Cc: | added |
---|
comment:4 by , 16 years ago
Cc: | added |
---|---|
Owner: | changed from | to
comment:5 by , 16 years ago
Milestone: | 1.5.1 → 1.6.0 |
---|
Patch commited in trunk in r14204 (with minor adaptations related to memory usage).
Is this appropriate for backporting into 1.5 branch ?
comment:6 by , 16 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Answering to myself ;-), I don't think it's appropriate. There have been quite a lot of changes in the postgres driver since 1.5 and that one is really new feature.
Closing
Mateusz,
I'd like you to add a way of specifying a table list is the PG: connection string. Perhaps an entry like TABLES=name1,name2,... could be allow to establish the set of tables to be scanned. This would need to be removed from the string before the rest is passed on to the postgres connection opening function.