How do I implement LISTEN/NOTIFY using a native database/sql connection?

[abhijit-hota]

I'm using sqlx along with pgx (just as a driver) for my application. How do I implement listen/notify?

[jackc]

Use conn.Raw() to get a *pgx.Conn from a *sql.Conn. See https://pkg.go.dev/github.com/jackc/pgx/[email protected]/stdlib for example.

Then use the *pgx.Conn as you would outside of database/sql.

[abhijit-hota]

Got it, thanks!