How to connect to PostgreSQL in Erlang using epgsql driver?

[S Sai Prasad]

Hello epgsql team,

I would to like access the PostgreSQL database using Erlang.I tried using `connect` function but I am getting an error in console.Please provide me the solution to the problem.

ERROR MESSAGE:

** exception error: undefined function epgsql:connect/1

     in function  example:demo/0 (example.erl, line 5)

[Sergey Prokhorov]

Hi.

Do you use rebar3 as a build tool?

суббота, 27 марта 2021 г. в 07:23:30 UTC+1, spr...@manufacanalytics.com:

[S Sai Prasad]

Yes

[Sergey Prokhorov]

Well, then make sure your project has

{deps, [epgsql]}.

and start erlang shell as `rebar3 shell`, not just `erl`

воскресенье, 28 марта 2021 г. в 17:29:15 UTC+2, spr...@manufacanalytics.com:

[Sergey Prokhorov]

{deps, [epgsql]}.  in rebar.conf file

понедельник, 29 марта 2021 г. в 03:18:03 UTC+2, Sergey Prokhorov:

[S Sai Prasad]

Hello Sergey,Problem resolved."rebar3 shell" worked.Thank you.

How to insert values into the table such that values are from function parameters?

Please check attached picture given below

[Сергей Прохоров]

Use `equery`, not `squery` when you need to attach dynamic data to your query:

```

epgsql:equery(C, "insert into mqtt_msg (topic, payload) values ($1, $2), [MqttTopic, MqttPayload])

```

вт, 30 мар. 2021 г. в 09:38, S Sai Prasad <spr...@manufacanalytics.com>:

--
You received this message because you are subscribed to a topic in the Google Groups "Erlang epgsql Postgres driver use and development" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/epgsql/6u_rdRrrC_s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to epgsql+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/epgsql/c99df749-70e2-48a0-bb1c-ddc965c069c8n%40googlegroups.com.