Re: adding two tables - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: adding two tables
Date
Msg-id 1097658529.21062.252.camel@sabrina.peacock.de
Whole thread Raw
In response to adding two tables  ("fx gamoy" <fx.gamoy@mapxplore.com>)
List 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.




pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: adding two tables
Next
From: Richard Huxton
Date:
Subject: Re: about permissions...