2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
Can you parameterize it the same way you'd parameterize a regular query? From what I could find, Postgres doesn't do parameterization on its own. This is normally provided by the calling code, for example pg-template-tag for Node.js.
répondu il y a 5 mois
Contenus pertinents
- demandé il y a 7 mois
- demandé il y a un an
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an
Hello,
What client-side libraries usually do is:
:value
into$1
)In other words: parameterized queries are handled as prepared statements.
I realized that PREPARE only handles SELECT, INSERT, UPDATE, DELETE, MERGE, or VALUES statements (cf. https://www.postgresql.org/docs/current/sql-prepare.html).
So, knowing that
aws_s3.query_export_to_s3
uses COPY behind the scenes, there is no way to use parameterized queries with it.Closing this question then (EDIT: no way to do that?).