adding two tables

From: "fx gamoy" <fx(dot)gamoy(at)mapxplore(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: adding two tables
Date: 2004-10-13 08:55:30
Message-ID: 008701c4b102$651cbe50$0201a8c0@geodev0
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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) ???
thanks
fx

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2004-10-13 09:08:10 Re: adding two tables
Previous Message Henriksen, Jonas F 2004-10-13 08:39:15 about permissions...