On 2011-08-23, Marc Mamin <M.Mamin@xxxxxxxxxxxx> 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 strings, e.g.:
>
>
> 'a,12,ght,45,1.2'
> 'b,13,ght,45,1.1'
> 'a,14,ght,45,1.5'
>
> in order to save this result into a table, I still need to quote the
> string value and use EXECUTE:
you can wrap it up and cast it to foo:
insert into foo select(('('|| 'a,12,ght,45,1.2' ||')')::foo).*;
-- etc
insert into foo select ('(a,12,ght,45,1.2)'::foo).*
union all select ('(b,13,ght,45,1.1)'::foo).*
union all select ('(a,14,ght,45,1.5)'::foo).*;
--
⚂⚃ 100% natural
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
