Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy data from table to table - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Copy data from table to table
Date
Msg-id 20050427133444.GA34371@winnie.fuhr.org
Whole thread Raw
In response to Copy data from table to table  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
Tree view 
On Wed, Apr 27, 2005 at 09:16:09AM -0400, Keith Worthington wrote:
>
> I can not think of a way to copy data directly betweeen two tables.

Have you tried INSERT ... SELECT?

INSERT INTO foo (a, b, c) SELECT a, b, c FROM bar;

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: Copy data from table to table
Next
From: George Weaver
Date:
Subject: Re: Copy data from table to table