Received: from primaire.intelcom.fr (primaire.intelcom.fr [194.250.33.1]) by hub.org (8.10.1/8.10.1) with ESMTP id e8DEfVs12086 for ; Wed, 13 Sep 2000 10:41:31 -0400 (EDT) Received: from volvo.intelcom.fr ([192.168.160.20]) by primaire.intelcom.fr (8.8.8+Sun/8.8.8) with SMTP id QAA12851 for ; Wed, 13 Sep 2000 16:40:54 +0200 (MET DST) Received: from intelcom.fr by volvo.intelcom.fr (SMI-8.6/SMI-SVR4) id QAA11410; Wed, 13 Sep 2000 16:40:45 +0200 Message-ID: <39BF91EC.6B7462BB@intelcom.fr> Date: Wed, 13 Sep 2000 16:40:44 +0200 From: Jerome Raupach X-Mailer: Mozilla 4.75 [en] (X11; U; SunOS 5.5 sun4d) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: work on some tables in the same time. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/87 I want to execute this query on some table2 in the same time : INSERT INTO table2_n(f1, f2, f3) SELECT DISTINCT f1, f2, f3 FROM table1_n ; ------------------------------------------------------------------ CREATE TABLE table1_1( INT2 f1, INT2 f2, INT2 f3, INT2 f4 ); CREATE TABLE table1_2( INT2 f1, INT2 f2, INT2 f3, INT2 f4 ); ... CREATE TABLE table2_1( INT2 f1, INT2 f2, INT2 f3 ); CREATE TABLE table2_2( INT2 f1, INT2 f2, INT2 f3 ); ... ------------------------------------------------------------------ Anyone can help me ? Thanks in advance. Jerome.