| From: | Federico Di Gregorio <fog(at)dndg(dot)it> |
|---|---|
| To: | "W(dot) Matthew Wilson" <matt(at)tplus1(dot)com>, "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org> |
| Subject: | Re: how to pass in bind variables with cursor.copy_expert? |
| Date: | 2014-02-21 16:47:02 |
| Message-ID: | 53078306.106@dndg.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
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(dot)digregorio(at)dndg(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2014-02-21 18:54:05 | Re: how to pass in bind variables with cursor.copy_expert? |
| Previous Message | W. Matthew Wilson | 2014-02-21 16:27:51 | how to pass in bind variables with cursor.copy_expert? |