Re: adding two tables

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: fx gamoy <fx(dot)gamoy(at)mapxplore(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: adding two tables
Date: 2004-10-13 09:08:49
Message-ID: 1097658529.21062.252.camel@sabrina.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi again,

On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
> hello everybody,
> i ve got two big tables with the same structure.
>
> i would like to add the second one to the first one directly without
> generating a sql file. (each table is about 1 Million line)
> Is it a way with an sql command?
> INSERT INTO TAB1... (select * from TAB2) ???

without ... and ( ) of course.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robin Ericsson 2004-10-13 09:21:11 query problem
Previous Message Tino Wildenhain 2004-10-13 09:08:10 Re: adding two tables