Running multiple statements with DBI

multi.R

library(DBI)
con <- dbConnect(
  RPostgres::Postgres(),
  ...
)

dbExecute(
  con,
  "CREATE TEMP TABLE x (a int); CREATE TEMP TABLE y (b int)",
  immediate = TRUE
)
#> [1] 0
dbGetQuery(con, "SELECT COUNT(*) FROM y")
#>   count
#> 1     0