Re: COPY FROM (query) in plpgsql

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: COPY FROM (query) in plpgsql
Дата
Msg-id j4fgeh$4pu$1@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на COPY FROM (query) in plpgsql  ("Marc Mamin" <M.Mamin@intershop.de>)
Список pgsql-general
On 2011-08-23, Marc Mamin <M.Mamin@intershop.de> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Preston Landers
Дата:
Сообщение: Re: PG producing odd results on epoch timestamp to string conversion
Следующее
От:
Дата:
Сообщение: Security setup.