Postgres Pro
Downloads
Home   >   mailing lists

Re: A better COPY? - Mailing list pgsql-general

From Tim Uckun
Subject Re: A better COPY?
Date
Msg-id CAGuHJrM0+vnr-4KYqRfH30fj4wEAR8NwkXrFnf5W=0dydgTxOA@mail.gmail.com
Whole thread Raw
In response to Re: A better COPY?  (Marti Raudsepp <marti@juffo.org>)
List pgsql-general
Tree view 
>
>> 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 by date:

Previous
From: Chris Travers
Date:
Subject: Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought
Next
From: Stefan Keller
Date:
Subject: Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought