How to log parameters instead of placeholders using sqlx with Postgres?

Asked Dec 30 '22 at 01:14

Active Jun 12 '23 at 20:56

Viewed 153 times

I'm using sqlx for the first time today.

I'm having really hard time understanding my SQL errors because I cannot copy & paste logged queries in my IDE because the parameters are not converted from placeholders.

It prints:

SELECT * from players where team_id = $1 AND id = $2

but I would like the below instead:

SELECT * from players where team_id = 'ABC' AND id = '123'

How to do this?

edited Jun 12 '23 at 20:56

Yuri Astrakhan

8,808
6
63
97

asked Dec 30 '22 at 01:14

Fred Hors

3,258
3
25
71

Instead of suggesting to close, can you please explain why this question is wrong? – Fred Hors Dec 30 '22 at 11:58
How do you log the queries? – Chayim Friedman Jun 13 '23 at 08:16
@ChayimFriedman I'm using `tracing_log::LogTracer` with tracing level `info`. – Fred Hors Jun 13 '23 at 12:50
I'd like to know how to do what you're saying as the problem, can you give a code example? – nectarine Sep 01 '23 at 17:42

How to log parameters instead of placeholders using sqlx with Postgres?

0 Answers0