Re: insert vs select into performance - Mailing list pgsql-performance

From Michael Stone
Subject Re: insert vs select into performance
Date
Msg-id 20070718113249.GI12481@mathom.us
Whole thread Raw
In response to Re: insert vs select into performance  (Thomas Finneid <tfinneid@student.matnat.uio.no>)
Responses Re: insert vs select into performance  (Thomas Finneid <tfinneid@student.matnat.uio.no>)
List 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

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: insert vs select into performance
Next
From: "Michael Dengler"
Date:
Subject: How to use a trigger to write rows to a remote server