At 09:16 AM 4/27/05, Keith Worthington wrote:
>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 query
>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 data
>from the file to the target table.
INSERT INTO ... (SELECT FROM ...)
What is the last word in synopsis?
In response to
pgsql-novice by date
|Next:||From: Van Ingen, Lane||Date: 2005-04-27 14:43:58|
|Subject: SQL COPY Command|
|Previous:||From: George Weaver||Date: 2005-04-27 13:36:00|
|Subject: Re: Copy data from table to table|