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:10
Message-ID: 1097658490.21062.250.camel@sabrina.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2004-10-13 09:08:49 Re: adding two tables
Previous Message fx gamoy 2004-10-13 08:55:30 adding two tables