Loading data

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

Browse pgsql-novice by date

  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