By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

adding two tables

P: n/a
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
Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2

P: n/a
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.


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

Nov 23 '05 #3

P: n/a
Hi
I have just to install postgreSQL-7.5. in windows 2003.
and the system send me this error :
Bad system call postmaster

Someone can help me ?

thanks U



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

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.