Re: psycopg2 open file for reading

On Wed, Oct 28, 2015 at 4:04 PM, Dan Sawyer <dansawyer(at)earthlink(dot)net> wrote:

> The file open command is:
>
> f = open("/tmp/test.txt","r")
>
> Is this correct? Is the read method syntax correct
>

Well, it looks correct. Do you get any errors with that?

On 10/28/2015 07:42 AM, Shulgin, Oleksandr wrote:
>
> On Wed, Oct 28, 2015 at 3:35 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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
>
>