How to use pgp.as.format for a transaction

Is it possible to use pgp.as.format to see raw postgres queries generated by a transaction db.tx(t => ...)? I can't figure out the syntax for this use-case.

1 answer

  • answered 2018-05-16 10:10 vitaly-t

    If you can't figure out what query is generated, you have the following options:

    • Start using pg-monitor that will show you all the queries automatically
    • Manually connect to event query
    • Use function as.format

    Is it possible to use pgp.as.format

    Why wouldn't it be possible? The function is there to be used independently whenever needed. But in your case, for viewing generated queries, the other two options are better.