Skip to content
Christoph Herrmann edited this page Oct 17, 2019 · 3 revisions
const table = 'users'

const result = await sql.query(sql`
  SELECT "*" FROM ${sql.table(table)}
`)

// text: SELECT "*" FROM "users"
// values: []

It's also possible to define a schema by giving table as array, e.g.:

const schema = 'account'
const table = 'users'

const result = await sql.query(sql`
  SELECT "*" FROM ${sql.table([schema, table])}
`)

// text: SELECT "*" FROM "account"."users"
// values: []

If all tables are in the same schema, there is also the option sql.defaultSchema.

Clone this wiki locally