2 Respostas
- Mais recentes
- Mais votos
- Mais comentários
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.
respondido há 6 meses
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há um ano
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?).