Loading data - Mailing list pgsql-novice

From Srinivas Iyyer
Subject Loading data
Date
Msg-id 20041011201957.11420.qmail@web61303.mail.yahoo.com
Whole thread Raw
List pgsql-novice
Dear Group,
 I have two tables:
1.
 exp_id | exp_name | exp_type | exp_desc | exp_logic
--------+----------+----------+----------+----------


2.
data_id | exp_id | data_present | data_past |
data_mean
---------+--------+--------+--------+------------------


I have my data_present, data_past and data_mean in a
text file. I have my exp_id in experiment table.

Now I have to load 10 different experimental data
(exp_id  range : 1-10)

How can I tell postgresql :

1. from which data_id my exp_id changes.  For example
data_id from 1 to 100 will be exp_id : 1 and data_id :
101-200 will be exp_id : 2. How will I know what was
the last data_id number and ask postgres to take the
next row as next exp_id.

Please help.

Thank you.

Srini



_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

pgsql-novice by date:

Previous
From: Kumar S
Date:
Subject: Download field in a column
Next
From: Oliver Elphick
Date:
Subject: Re: Where is the log file