How to connect to postgresql db from uipath

[loginerror (Maciej Kuźmicz)]

Just to spread the information around, see also this post:

How to use postgresql database in database connectivity in UiPath?

for those still having issues with the Insert Activity. I posted in another thread the solution after debugging my issues. make sure that Postgres database database or table names does not contain any special characters. For example, postgreSQL allows hyphens in the database or table names. But errors will be generated if the name of the database or table contain hyphen. column names must match the datatable add a primary key to your database table. column names must be in lower case!! someh…