Re: [sqlalchemy] emulating psql's "\copy" function?

2015-10-13 Thread Jon Nelson
On Tue, Oct 13, 2015 at 2:49 PM, Jon Nelson wrote: > On Tue, Oct 13, 2015 at 1:55 PM, Jonathan Vanasco > wrote: >> As part of an archiving routine that uses SqlAlchemy, I need to execute some >> pretty specific commands using `\copy` to archive a

Re: [sqlalchemy] emulating psql's "\copy" function?

2015-10-13 Thread Jon Nelson
On Tue, Oct 13, 2015 at 1:55 PM, Jonathan Vanasco wrote: > As part of an archiving routine that uses SqlAlchemy, I need to execute some > pretty specific commands using `\copy` to archive a selection of columns, in > a special order, into a csv. > > Doing some digging,

[sqlalchemy] emulating psql's "\copy" function?

2015-10-13 Thread Jonathan Vanasco
As part of an archiving routine that uses SqlAlchemy, I need to execute some pretty specific commands using `\copy` to archive a selection of columns, in a special order, into a csv. Doing some digging, psycopg2 provides an interface to `COPY` -- but that doesn't work for my needs. I'd