Re: A better COPY?

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: A better COPY?
Дата
Msg-id CAGuHJrM0+vnr-4KYqRfH30fj4wEAR8NwkXrFnf5W=0dydgTxOA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A better COPY?  (Marti Raudsepp <marti@juffo.org>)
Список pgsql-general
>
>> 1. COPY from a text field in a table like this COPY from (select
>> text_field from table where id =2) as text_data ...
>
> The syntax is a bit different:
> CREATE TABLE text_data AS select text_field from table where id=2


Really? Wow, I would have never guessed that. That's awesome.

Thanks.

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

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought
Следующее
От: Stefan Keller
Дата:
Сообщение: Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought