Frank Bax wrote:
> At 09:16 AM 4/27/05, Keith Worthington wrote:
>> Hi All,
>> I can not think of a way to copy data directly betweeen two tables.
>> I can only think of two ways to copy the data indirectly.
>> Method 1: Write a function that loops through the results of a select
>> running individual inserts for each record.
>> Method 2: Use SELECT INTO to put the desired data in a temporoary
>> table; then
>> use COPY to store the data in a file and finally use COPY to read the
>> from the file to the target table.
> INSERT INTO ... (SELECT FROM ...)
Thank you all very much. I had not run across this command yet. I have
run a few queries using it and it is going to work quite nicely for me.
In response to
pgsql-novice by date
|Next:||From: Richard Lynch||Date: 2005-04-28 03:50:44|
|Subject: Re: [PHP] temp tables|
|Previous:||From: jeffwalton||Date: 2005-04-27 23:48:37|
|Subject: error: relation <tableName> does not exist|