Re: Postgres COPY Command with python 2.3 pg

2005-02-17 Thread gry
import pg db = pg.DB('bind9', '192.168.192.2', 5432, None, None, 'named', None) db.query('create temp table fffz(i int,t text)') db.query('copy fffz from stdin') db.putline("3\t'the'") db.putline("4\t'rain'") db.endcopy() db.query('commit') Note that multiple columns must be separated by tabs ('\t

Re: Postgres COPY Command with python 2.3 pg

2005-02-15 Thread Michael Lang
On 2005-02-15, @(none) <""> wrote: > Michael Lang wrote: >> using psql it works fine, but i dont know how to get it working in python. >> Ive already made the calls but the changes never apper, and no error. > > Which Postgres module are you using? I had the exct same problem when I > first starte

Re: Postgres COPY Command with python 2.3 pg

2005-02-15 Thread @(none)
Michael Lang wrote: using psql it works fine, but i dont know how to get it working in python. Ive already made the calls but the changes never apper, and no error. Which Postgres module are you using? I had the exct same problem when I first started using pyPgSQL, until I figured out that I neede