Home > mailing lists

adding two tables - Mailing list pgsql-general

From	fx gamoy
Subject	adding two tables
Date	October 13, 2004 12:49:33
Msg-id	008701c4b102$651cbe50$0201a8c0@geodev0 Whole thread Raw
Responses	Re: adding two tables Re: adding two tables
List	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

From: "Henriksen, Jonas F"
Date: 13 October 2004, 12:38:33
Subject: about permissions...

From: Tino Wildenhain
Date: 13 October 2004, 13:08:33
Subject: Re: adding two tables