work on some tables in the same time.

From: Jerome Raupach <jraupach(at)intelcom(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: work on some tables in the same time.
Date: 2000-09-13 14:40:44
Message-ID: 39BF91EC.6B7462BB@intelcom.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-09-13 15:36:50 Re: Optimizing Multiply Joins ???
Previous Message Meszaros Attila 2000-09-13 14:16:57 Optimizing Multiply Joins ???