table name substitution in static rust postgres query using numeric parameters

[endermaz41]

The code breaks as soon as I try to substitute the table name with a numeric variable.

I get syntax error at $1.

Am I supposed to escape it ?

If the issue is numeric parameters, I can try something else.

let players = sqlx::query_as!(
              DatabaseGym,
              "select * from ( select * FROM $1 where player=$2 and time <= $3 ORDER BY time desc limit $4  ) temp ORDER BY time asc;",
              matched_table.to_owned(),
              player.to_owned(),
              &x.time,
              count
              ).fetch_all(&self.pg_pool)
              .await.unwrap();