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

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>

• https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/information_services.html

• https://www.cdata.com/kb/tech/postgresql-jdbc-spotfire-server.rst