PostgreSQL/PostGIS Named Connection Example - spectrum_spatial - Latest

Spectrum Spatial Guide

Product type
Software
Portfolio
Locate
Product family
Spectrumâ„¢ software
Product
Spectrumâ„¢ software > Spatial > Spectrum Spatial
Version
Latest
ft:locale
en-US
Product name
Spectrum Technology Platform
ft:title
Spectrum Spatial Guide
Copyright
2025
First publish date
2007
ft:lastEdition
2025-09-26
ft:lastPublication
2025-09-26T10:03:58.880000

This is an example of a named connection to a PostgreSQL/PostGIS table.

<?xml version="1.0" encoding="UTF-8"?>
<NamedConnection version="MXP_NamedResource_1_5" xmlns="http://www.mapinfo.com/mxp">
<DBConnection dbType="postgis">
          <ConnectionName>Connection_1</ConnectionName>
           <JDBCDriverParameters>
                <JDBCUrl>@jdbcurl@</JDBCUrl>
                <DriverPropertySet>
                     <Property name="user" value="@user@"/>
                     <Property name="password" value="@password@"/>
                </DriverPropertySet>
           </JDBCDriverParameters>
     </DBConnection>
</NamedConnection>
Note: The @jdbcurl@ used to connect to the database would be in the form
jdbc:postgresql://@host@:@port@/@databasename@