work on some tables in the same time. - Mailing list pgsql-sql

From Jerome Raupach
Subject work on some tables in the same time.
Date
Msg-id 39BF91EC.6B7462BB@intelcom.fr
Whole thread Raw
Responses Re: work on some tables in the same time.  (Ian Turner <vectro@pipeline.com>)
Re: work on some tables in the same time.  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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.


pgsql-sql by date:

Previous
From: Meszaros Attila
Date:
Subject: Optimizing Multiply Joins ???
Next
From: Tom Lane
Date:
Subject: Re: Optimizing Multiply Joins ???