Re: how to pass in bind variables with cursor.copy_expert?

On 21/02/2014 17:27, W. Matthew Wilson wrote:
> I need to extract some rows from a table as a CSV file, based on a
> query sort of like:
>
>     copy (
>         select *
>         from blah
>         where x = %(x)s
>     )
>
> but I don't see how to pass in a dictionary with values for the query!

You can use cursor.mogrify() to build the query and then pass it to
cursor.copy_export(). See the documentation for the details.

federico

--
Federico Di Gregorio                         federico.digregorio@dndg.it
Di Nunzio & Di Gregorio srl                               http://dndg.it
 Everything will be OK at the end. If it's not OK, it's not the end.
                                                              -- Unknown