| 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: | Whole Thread | Raw Message | 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 |