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
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 |