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:
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:
[postgres]Server=<HOST>;Port=5432;Database=postgres;Username=postgres;Password=<PASSWORD>;SSL Mode=Require;Trust Server Certificate=true;
SQL Query
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.
select Email from public."Approvers"
