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.

Execution properties

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 indicating if Proj is support for PostGis. 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.

results matching ""

    No results matching ""