UiPath Go ! BalaReva PostgreSQL

Hi Guys,
I have successfully uploaded PostgreSQL in UiPath Go.This package contains the below activities .

  1. Execute DataTable

This brings the information from database even if you use the direct query or stored procedure.

  1. Execute NonQuery

It helps to execute To insert, update and delete statements.

  1. Execute Scalar

Returns the first column of the first row in the result set returned by the query or stored procedure as Object.

Regards
Balamurugan.S

7 Likes

Awesome!!! Great work bro!!!

1 Like

Thank you @Lahiru.Fernando

1 Like

Awesome! :slightly_smiling_face:

1 Like

Hello Sir,
I have an error something as picture below. Cloud you please help ?

1 Like

Hi ,
can you attach your project ?

Regards
Balamurugan.S

Hello Balamurugan,
Could you please resolve them? :sweat_smile:
POCConnection.xaml (4.5 KB) project.json (1.2 KB)

Best Regards,
Tanakorn P.

1 Like

Hi @Tanakorn_boy,

I have seen your xaml. The connection is ok. But you have to take look in the select query. When we are using the direct select query it may give error. But if try like below .It works well.

SELECT * FROM public.“tblCustomer” limit 1

Ref : Web
https://social.msdn.microsoft.com/Forums/tr-TR/808e59da-5bf1-439d-b5f4-89878797be20/error-42p01-relation-does-not-exist-hatas?forum=csharptr

Regards
Balamurugan.S

Hello @balupad14
I have checked them with your guide but see same error. Do u have more solution for advise me or more solution for fix this issue? Thank you in advance


1

Best Regards,
Tanakorn P.

1 Like

Hi @Tanakorn_boy,

I will look on it and get back to you. For me it working well. Please check the port that you have accessing thru Uipath. This weekend send a video about this. we can see. If possible we discuss about it on this weekend. Thank you very much to your feedback.

Thank you
Balamurugan.S

Hi,

can you select the query with schema like

Select * from public.tblcustomer

Regards
Balamurugan.S

Hi Sir,
Sorry to late, I query like that with last comment from you it’s work but when query on uipath it doesn’t work, still same that error.

BestRegard,
Tanakorn P.