Information designer data source using PostgreSQL will not show functions.

In TIBCO Spotfire version 10.10 and 11.4, you will not be able to see PostgreSQL functions listed in data sources that is set up using the Information designer tool.

This is due to a change in the handling of metadata in newer PostgreSQL .jar files, this has been fixed in TIBCO Spotfire Server 11.5.

There is a workaround that you can use that is outlined in this article:

https://community.spotfire.com/articles/spotfire/spotfire-server-information-designer-fix-issues-with-postgresql-functions-not-showing-in-list-of-database-objects/