PostGIS Writer Parameters

About Database Connections

Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see Using Database Connections.

Note that Database Connection parameters differ slightly, depending on context and/or database format.

Connection

From the Connection parameter in a database format, you can do one of the following:

  • Select an existing, previously defined connection. See the section Reusing a Database Connection in Using Database Connections
  • Select Add Database Connection to define a new connection. See database-specific parameters below, as well as the section Adding a Database Connection in a Workspace in Using Database Connections The new connection can be made visible only to the current user, or can be shared among multiple users.

Database Connection

Select an existing PostgreSQL database connection, or Add Database Connection...

Add PostGIS/PostgreSQL Database Connection

To define a new connection from the Connection parameter in a PostGIS format, see the topic PostGIS: Add Database Connection.

Table Creation

Spatial Column Type

Select either geography or geometry columns for the table.

Spatial Column

Enter a name for the table.

Create Generic Geometry Columns

This setting applies at generation time, not at translation time. The default setting of "no" indicates that you want to create geometrically constrained geometry columns on the destination tables. For example, a POINT geometry table would be restricted only to points. Now you have the option to create generic or non-constrained geometry column types.

Effectively this means you can insert multiple geometry types into one table. Specifically the geometry column is created to have the generic type GEOMETRY and there are no constraints placed on the geometry types allowed.

Lower Case Attribute Names

If checked, changes the case of attribute names to lowercase.

Advanced