See values behind parameterized INSERTs

Is there any way to see what values were actually passed with a parameterized INSERT? For example;
INSERT INTO t1 (id, col1) VALUES (?, ?)
... is how the transaction appears in the dc_ tables and vertica.log.


  • Options

    Can't you use something like

    select request from v_monitor.query_requests where request like '%insert%'

    to see your insert statement and its values

  • Options
    I think you might be onto something; it looks like dc_requests_* has the values.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file