PostgreSQL translator (postgresql)
Also see common JDBC translators information.
The PostgreSQL translator, known by the type name postgresql, is for use with the following PostgreSQL client and server versions: * Client — 8.0 or later * Server — 7.1 or later.
PostgreSQL-specific execution properties:
- PostGisVersion
-
Indicates the PostGIS version in use. Defaults to 0, which means that PostGIS is not installed. Will be set automatically if the database version is not set.
- ProjSupported
-
Boolean that indicates if the PostGis version supports PROJ coordinate transformation software. Will be set automatically if the database version is not set.
Note
|
Some driver versions of PostgreSQL will not associate columns to "INDEX" type tables. The current version of Teiid omits such tables automatically. Older versions of Teiid may need the importer.tableType property or other filtering set. |