PostGIS geometry columns (following RFC 41 : Support for multiple geometry fields in OGR)įor such a table, a single OGR layer will be reported with as many OGR supports reading, updating, creating tables with multiple Tables with multiple PostGIS geometry columns. 'foo' (implicitly within 'bar_schema') and 'public.foo'. That you specify active_schema=bar_schema, 2 layers will be listed : Public schema, and a table 'foo' within the 'bar_schema' schema, and For example, if you have a table 'foo' within the The name of the tables within that active schema will not be prefixed by Note that this does not restrict the tables that will be The active schema is the schema where tables areĬreated or looked for when their name is not explicitly prefixed by a The active schema ('public' being the default)Ĭan be overridden by specifying active_schema=schema_name within theĬonnection string. Otherwise, theĪctive schema is still 'public', unless otherwise specified by the (and the schema name will not prefix the layer name). Schema is listed, it will also be made automatically the active schema PostgreSQL database if there are a lot of schemas. This can also be a way of speeding up the connection to a This can be doneīy specifying schemas=schema_name within the connection Will be scanned while establishing the list of tables. It is possible to restrict the schemas that Skips enumeration of the tables as described in the next paragraph. Will not bring further noticeable speed-ups. The database opening should be significantlyįaster than in previous versions, so using tables= or schemas= options Connection options related to schemas and tables The information collected in that page deal with advanced topics, notįound in the OGR PostgreSQL driver Information page. PostgreSQL / PostGIS - Advanced Driver Information
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |