How to insert data into PostgreSQL table using Uipath?

Help
1

Hi all
I am trying to insert a values into the table in PostgreSQL database through Execute Non-Query activity.I used ODBC driver to connect the PostgreSQL database.
But I got an error in insert query. Please help me with the connection of PostgreSql with Uipath.

2

Hi @Balasundari

A good start would be to provide more information about your query and the error you’ve received.

3

Hi @loginerror
I got following error message when I tried insert query
( *Execute query: ERROR [42S02] [Microsoft][ODBC dBASE Driver] The Microsoft Access database engine could not find the object ‘Employee’. Make sure the object exists and that you spell its name and the path name correctly. If ‘Employee’ is not a local object, check your network connection or contact the server administrator)
Please suggest some ideas regarding which database driver would be best and effective to connect PostgreSQL through Uipath.

4

I would try this link first, it seems to have a clue on what might be going on.

1 Like
5

Hi,
You can get the Postgresql from UiPath Go!

Regards
Balamurugan.S

8

yes i know that how to insert the simple message into postgre,like type string and number,but I do not know how to transfer the byte data to that SQL