Re: adding two tables - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: adding two tables
Date
Msg-id 1097658490.21062.250.camel@sabrina.peacock.de
Whole thread Raw
In response to adding two tables  ("fx gamoy" <fx.gamoy@mapxplore.com>)
List pgsql-general
Hi,

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 the ... your statement is complete.

Have fun
Tino


pgsql-general by date:

Previous
From: "fx gamoy"
Date:
Subject: adding two tables
Next
From: Tino Wildenhain
Date:
Subject: Re: adding two tables