PostgreSQL External Bindings

PostgreSQL support was added to the External Bindings functionality in GlobalSearch 6.3.344.

Connection Strings

You can read more about the options available for PostgreSQL Connection Strings at the link below;
https://www.connectionstrings.com/postgresql/

A typical PostgreSQL connection string can be found below;

CODE

Host=<HOST>;Port=5432;Database=postgres;Username=postgres;Password=<PASSWORD>;

Note that the table name may need to appear in quotes if the table name contains capital letters

GlobalSearch will use the first column returned from the SQL query to populate the list.

CODE

select Email from public."Approvers"