Re: [GENERAL] COPY FROM (query) in plpgsql

2011-09-10 Thread Jasen Betts
On 2011-08-23, Marc Mamin wrote: > Hello, > > there seems to be no way to use COPY this way, so I guess this is a > feature request... > > this may also help users who tried using COPY FROM STDIN in plpgsql. > > > I have a query with a lot of string manipulation that returns data as > single strin

Re: [GENERAL] COPY FROM (query) in plpgsql

2011-08-23 Thread Vincent Veyron
Le mardi 23 août 2011 à 11:29 +0200, Marc Mamin a écrit : > Hello, > > there seems to be no way to use COPY this way, so I guess this is a > feature request... > > this may also help users who tried using COPY FROM STDIN in plpgsql. > > > I have a query with a lot of string manipulation that re

[GENERAL] COPY FROM (query) in plpgsql

2011-08-23 Thread Marc Mamin
Hello, there seems to be no way to use COPY this way, so I guess this is a feature request... this may also help users who tried using COPY FROM STDIN in plpgsql. I have a query with a lot of string manipulation that returns data as single strings, e.g.: 'a,12,ght,45,1.2' 'b,13,ght,45,1.1' 'a