Postgres Pro
Downloads
Home   >   mailing lists

Re: psycopg2 open file for reading - Mailing list psycopg

From Shulgin, Oleksandr
Subject Re: psycopg2 open file for reading
Date
Msg-id CACACo5SNtSO5vwoFw26fZe2PwWv0WBXfGFJYcbFHGnry364y0Q@mail.gmail.com
Whole thread Raw
In response to Re: psycopg2 open file for reading  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: psycopg2 open file for reading  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: psycopg2 open file for reading  (Dan Sawyer <dansawyer@earthlink.net>)
List psycopg
Tree view
On Wed, Oct 28, 2015 at 3:35 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

The cheat is to read the on disk file and write it into an in memory file and then use that with STDIN. Something like:

sql_copy = "COPY " + self.pg_tbl_name
sql_copy += " FROM STDIN WITH CSV DELIMITER '\t'"
cur_copy.copy_expert(sql_copy, mem_file)

And you don't actually need a "memory file", any object implementing "read" method, such as a normal fie object should just work:

file=open('1.txt', 'r')
cur_copy.copy_expert(sql_copy, file)

--
Alex

psycopg by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psycopg2 open file for reading
Next
From: Adrian Klaver
Date:
Subject: Re: psycopg2 open file for reading