Using parameter with table alias in postgres

Question

I'm new to node-postgres and trying to pass in parameters connected to a table alias, but it's not working. How can I parameterize the simple query below? Take something like

const pgQuery = 'SELECT t1.YEAR as year, t1.CODE as code FROM data t1;';

and instead do something like

const pgQuery = 'SELECT t1.$1 as year, t1.$2 as code FROM data t1;';
const values = ['YEAR', 'CODE'];

Adrian Klaver · Accepted Answer · 2021-07-12 22:09:48Z

1

Per the docs here:

https://node-postgres.com/features/queries

PostgreSQL does not support parameters for identifiers. If you need to have dynamic database, schema, table, or column names (e.g. in DDL statements) use pg-format package for handling escaping these values to ensure you do not have SQL injection!

Which takes you here:

https://www.npmjs.com/package/pg-format

Repo:

https://github.com/datalanche/node-pg-format

answered Jul 12, 2021 at 22:09

Adrian Klaver

20.3k3 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using parameter with table alias in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related