PostgreSQL/PostGIS Database Table

Example

This is an example of a named table definition for a PostgreSQL/PostGIS database table, using the PostGIS data provider.

In this example, the definition defines a connection to a PostGIS database table using the following tokens:

  • @jdbcurl@ the jdbc url used to connect to the database, which is of the form jdbc:postgresql://@host@:@port@/@databasename@
  • @host@ the host name used to connect to the database
  • @port@ the port number used to connect to the database
  • @databasename@ the name for the instance
  • @user@ the user name credentials to access the table
  • @password@ the password credentials for accessing the database
  • @table@ the name of the table in the database
  • @schema@ the schema used by the database. For example: public
  • @named_connection_path@ the name of the named connection with path in the repository
<?xml version="1.0" encoding="UTF-8"?>
<NamedDataSourceDefinition version="MXP_NamedResource_1_5" xmlns="http://www.mapinfo.com/mxp">
     <ConnectionSet>
           <NamedConnectionRef resourceID="@named_connection_path@">
                <ConnectionName>Connection_1</ConnectionName>
           </NamedConnectionRef>
     </ConnectionSet>
     <DataSourceDefinitionSet>
           <DBDataSourceDefinition id="dbDataSourceDef1" volatile="true">
                <DataSourceName>PostgresqlDataSource</DataSourceName>
                <ConnectionMember>
                     <ConnectionName>Connection_1</ConnectionName>
                </ConnectionMember>
                <DBTable owner="@schema@" useQuotes="true">@table@</DBTable>
           </DBDataSourceDefinition>
     </DataSourceDefinitionSet>
     <DataSourceRef ref="dbDataSourceDef1"/>
</NamedDataSourceDefinition>