|Postgresql COPY||Yang Zhang||4/15/11 12:17 AM|
Is it possible to execute a Postegresql COPY ... FROM STDIN statement
via sqlalchemy, or do we have to drop down to psycopg2 for that
Tried executing a COPY statement followed directly by the input
values, as in psql, but that didn't work. Thanks in advance.
|Re: [sqlalchemy] Postgresql COPY||Michael Bayer||4/15/11 7:37 AM|
SQLAlchemy doesn't have functions that connect to psycopg2's "copy_from()" etc. methods and from psycopg2s docs it seems this is how those functions are usable, as opposed to emitting the word "COPY". So you know as much as I do here, and you likely have to use the psycopg2 connection. you can get one from the pool via engine.raw_connection() if you wanted.
> You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
> To post to this group, send email to sqlal...@googlegroups.com.
> To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
|Re: [sqlalchemy] Postgresql COPY||Manlio Perillo||4/15/11 9:38 AM|
-----BEGIN PGP SIGNED MESSAGE-----
Il 15/04/2011 09:17, Yang Zhang ha scritto:
The problem is that psycopg2, if I'm not wrong, only supports an high
psycopg2, instead, implements custom methods for copy support (I assume