Re: Copying data from one table to another - Mailing list pgsql-general

From Björn Lundin
Subject Re: Copying data from one table to another
Date
Msg-id c1qflv$nf8$1@news.hub.org
Whole thread Raw
In response to Copying data from one table to another  (Erwin Van de Velde <erwin.vandevelde@ua.ac.be>)
List pgsql-general
Erwin Van de Velde wrote:

> Hi,
>
> I have to copy data from one table to another, and I was wondering if
> there is an easier way to do that than to have a lot of inserts one after
> another.

insert into target_table select * from source-table where ...;

Björn Lundin


pgsql-general by date:

Previous
From: "Benson Lei"
Date:
Subject: installation -- help ?
Next
From: Joe Maldonado
Date:
Subject: postmaster out of memory....