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')
Hi to all,
can some one point me to the correct way, how to use PostgreSQLs COPY feature
from within python ?
What i want to do is:
connect
start transaction
drop current tablecontens
copy new content from STDIN # file need more privileged user rights
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
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 started using
