Re: Copy data from one table to another

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: <KeithW(at)narrowpathinc(dot)com>, PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Copy data from one table to another
Date: 2006-02-24 18:58:01
Message-ID: C024C169.68D2%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2/24/06 1:42 PM, "Keith Worthington" <keithw(at)narrowpathinc(dot)com> wrote:

> Hi All,
>
> Would someone be so kind as to remind me of the syntax required to copy data
> from one table to another?

Hi, Keith. Will:

Insert into table2 [column1, ...]
Select * from table1;

Do what you want?

Sean

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Guido Barosio 2006-02-24 19:19:58 Re: Copy data from one table to another
Previous Message Keith Worthington 2006-02-24 18:42:22 Copy data from one table to another