Re: Copy data from table to table

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
>> 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 ...)
>
> http://www.postgresql.org/docs/8.0/interactive/sql-insert.html
>

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.

--
Kind Regards,
Keith