Re: Copying data from one table to another

From: Björn Lundin <bnl(at)tiscali(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Copying data from one table to another
Date: 2004-02-28 16:29:51
Message-ID: c1qflv$nf8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-02-28 16:40:26 Re: Copying data from one table to another
Previous Message Erwin Van de Velde 2004-02-28 16:08:09 Copying data from one table to another