Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group