From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Dominik Czarnota <dominik(dot)b(dot)czarnota(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Does PLPythonU support COPY table FROM string? |
Date: | 2015-08-28 15:15:07 |
Message-ID: | 55E07AFB.60407@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 08/28/2015 05:58 AM, Dominik Czarnota wrote:
> Hello,
>
> Is there any possibility to make COPY from list of records in PLPythonU?
>
> I've tried to simply call `plpy.execute(query)` with such query:
>
> COPY table (field1, field2, field3) FROM STDIN DELIMITER',';
> val1,val2,val3
> \.
>
> But it fails with not so explicit error:
> ProgrammingError: (psycopg2.ProgrammingError) spiexceptions.SyntaxError:
> syntax error at or near "val1"
> LINE 2: val1,val2,val3
> ^
The above is a psycopg2 error, so where are you running this and how?
>
> However the same thing works in psql.
>
> After some googling I found out that it doesn't work inside sql
> functions because there is no STDIN (
> http://www.postgresql.org/message-id/000501c5acc9$83747aa0$0501a8c0@plexus
> ).
>
>
> I've got working solution which was saving tmp file and then calling
> `COPY table FROM 'path'` but that's not cool.
>
> Did I miss something in plpythonu api? If not, where can I post "feature
> request" for that?
> Or can you point me place where I could dig into the code and implement it?
>
>
> ----
> Dominik Czarnota
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Dominik Czarnota | 2015-08-28 15:32:54 | Re: Does PLPythonU support COPY table FROM string? |
Previous Message | David Nelson | 2015-08-28 15:07:41 | Re: UPDATE an updatable view |