Please help

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Please help
Date: 2005-03-01 17:32:53
Message-ID: 20050301173253.98273.qmail@web51404.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello all,

I have a table and it has is like this:
exp_id
exp_name
exp_type
exp_desc
exp_pmid
exp_paper
exp_author
genechip_id
exp_rawdata_link
con_id
Indexes:
"experiment_pkey" primary key, btree (exp_id)
Foreign-key constraints:
"$1" FOREIGN KEY (genechip_id) REFERENCES
genechip_array(genechip_id)
"$2" FOREIGN KEY (con_id) REFERENCES
contacts(con_id)

Based on the data I have information that should fill
in this column U133A.

What I have in the genechip_array table is

genechip_id | fc_genechip_array |gc_spec
--+----------------------+------------------

5 | Human Genome U133A Array | Homo sapiens

Now how can I bring in the foreign key 5 to my
previous table. All I have is U133A.

Could any one help me in this.

Thank you.


__________________________________
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2005-03-01 17:55:55 Re: Please help
Previous Message Keith Worthington 2005-03-01 17:06:34 Re: Import csv file into multiple tables in Postgres