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 for list bindings can be found here:

CODE

Host=<HOST>;Port=5432;Database=postgres;Username=postgres;Password=<PASSWORD>;SslMode=Require;Trust Server Certificate=true;

A typical PostgreSQL connection string for DataXchange can be found here:

CODE

[postgres]Server=<HOST>;Port=5432;Database=postgres;Username=postgres;Password=<PASSWORD>;SSL Mode=Require;Trust Server Certificate=true;

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"