From: | Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Loading data |
Date: | 2004-10-11 20:19:57 |
Message-ID: | 20041011201957.11420.qmail@web61303.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2004-10-12 09:24:42 | Re: Where is the log file |
Previous Message | Kumar S | 2004-10-11 19:27:32 | Download field in a column |