How to run a query with multiple statements?

[curiosport]

I would like to execute 2 queries in a single statement that affect two different tables.

This is what I have and it works:

field := "Something"

_, _ = dbpool.Exec(
	context.Background(),
	`DELETE FROM example.table1 WHERE oneColumn = ($1);`,
	field,
)

_, _ = dbpool.Exec(
	context.Background(),
	`INSERT INTO example.table2 (otherColumn) values ($1);`,
	field,
)

This is what I want:

field := "Something"

_, _ = dbpool.Exec(
	context.Background(),
	`DELETE FROM example.table1 WHERE oneColumn = ($1); INSERT INTO example.table2 (otherColumn) values ($1);`,
	field,
)

And this is what I get:
"cannot insert multiple commands into a prepared statement"

It is not in my interest to have them run simultaneously I just want to simplify the code.

[jackc]

I would like to execute 2 queries in a single statement

The wire protocol only allows binding params into a single statement.

If you really want to use a single round trip you could use a writable CTE or you could use a Batch to bundle both together. But unless you have a specific reason, I would leave it as two commands.

[curiosport]

I understand it is to avoid SQL injections, but I was expecting pgx to have a For function that iterates on each command and executes them independently. But well, from your answer I see that the best for now is to use two commands. So thank you very much for the information.