[PyGreSQL] Copy support for pgdb

Sean Davis sdavis2 at mail.nih.gov
Thu Sep 21 12:28:03 EDT 2006


On Thursday 21 September 2006 12:06, D'Arcy J.M. Cain wrote:
> On Thu, 21 Sep 2006 08:34:13 -0400
>
> Sean Davis <sdavis2 at mail.nih.gov> wrote:
> > Just wondering--is there copy support for the pgdb module, or do I need
> > to stick with the pg module for it?
>
> Not sure what copy support you mean (import? inserttable?)  but you can
> always add functionality from the other module.  Give me some more
> details on what you are trying to do and I will try to show you.

By copy support, I mean writing rows directly to the server socket.  I can do 
this with pg like so:

db.query('copy table from stdin')
for row in rows:
    db.putline(row + "\n")
db.endcopy()

I can import and connect via pg for this, but using pgdb instead seems like it 
might be worth it for the future.  

Thanks for the quick response.

Sean


More information about the PyGreSQL mailing list