PostGIS Reader Parameters

Add Named Database Connection: Named Connections store (in a central location) authentication information associated with a user.

For information about setting up and using named connections, please see:

Using Named Database Connections

This specifies the machine running the PostGIS/PostgreSQL ORDBMS as either an IP address or host name. The database must have proper permissions and be set up to accept TCP/IP connections if connecting from a remote machine.

When connecting remotely, this specifies the TCP/IP port on which to connect to the ORDBMS service. The default port is 5432.

This specifies the name of the PostGIS-enabled PostgreSQL database. The database must exist in the ORDBMS.

Enter the username and password to access the database, user account, or wherever authentication is required.

If this is not set, the Table List dialog will only show choices from the Postgres search path for the current user. Selecting specific schemas here will cause tables from those schemas to be shown instead.

After you have completely specified the database connection, click the Browse button to select tables for import. A connection window appears while the system compiles a table from the database.

Once the table list appears, you can select one or more tables, and then click OK to dismiss the window. The table name(s) will appear in the table list field in the Parameter box.

This parameter exposes Format Attributes in Workbench when you create a workspace:

• In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
• In a non-dynamic scenario where you have multiple feature types, it is convenient to expose additional attributes from one parameter. For example, if you have ten feature types and want to expose the same attribute in each one, it is easier to define it once than it is to set each feature type individually in the workspace.

Using the minimum and maximum x and y parameters, define a bounding box that will be used to filter the input features. Only features that interact with the bounding box are returned.

If all four coordinates of the search envelope are specified as 0, the search envelope will be disabled.

Select this option to remove any portions of exported features outside the area of interest.