How to make Partitioned tables from PostgreSQL visible in the Information Designer data source.

Product:TIBCO Spotfire Server
Versions:All Supported versions

Summary:
How to make Partitioned tables from PostgreSQL visible in the Information Designer data source.

Details:

This article explains how to make partitioned tables from PostgreSQL visible in the Information Designer data source.

Resolution:

To display the partitioned tables, you need to add the value 'PARTITIONED TABLE' in the <table-types> attribute in the data source template as shown below.

<jdbc-type-settings>
<type-name>postgreSQL</type-name>
<driver>org.postgresql.Driver</driver>
<connection-url-pattern>
jdbc:postgresql://&lt;host&gt;:&lt;port&gt;/database
</connection-url-pattern>
<ping-command>select version()</ping-command>
<supports-procedures>true</supports-procedures>
<table-types>TABLE,VIEW,MATERIALIZED VIEW,PARTITIONED TABLE</table-types>
<condition-list-threshold>10000</condition-list-threshold>
<date-literal-format-expression>{d ‘$$value$$‘}</date-literal-format-expression>
<time-literal-format-expression>{t ‘$$value$$‘}</time-literal-format-expression>
<date-time-literal-format-expression>{ts ‘$$value$$’}</date-time-literal-format-expression>
<use-ansii-style-outer-join>true</use-ansii-style-outer-join>
<sql-runtime>com.spotfire.ws.im.ds.sql.postgresql.PostgresSQLRuntime</sql-runtime>
<java-to-sql-type-conversions>
<type-mapping>
<from>Boolean</from>
<to>BOOLEAN</to>
</type-mapping>
</java-to-sql-type-conversions>
</jdbc-type-settings>