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

Hi,

On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
without the ... your statement is complete.

Have fun
Tino


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Hi again,

On Wed, 2004-10-13 at 10:55, fx gamoy wrote:
without ... and ( ) of course.




---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Hi
I have just to install postgreSQL-7.5. in windows 2003.
and the system send me this error :

thanks U







---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster