Re: insert vs select into performance

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: insert vs select into performance
Date: 2007-07-18 11:32:50
Message-ID: 20070718113249.GI12481@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Jul 17, 2007 at 11:01:15PM +0200, Thomas Finneid wrote:
>Arjen van der Meijden wrote:
>>Have you also tried the COPY-statement? Afaik select into is similar to
>>what happens in there.
>
>No, because it only works on file to db or vice versa not table to table.

I don't understand how the insert you described is table to table?

Mike Stone

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Dengler 2007-07-18 13:36:33 How to use a trigger to write rows to a remote server
Previous Message Michael Stone 2007-07-18 11:31:43 Re: insert vs select into performance