| From: | fpirotti <francesco(dot)pirotti(at)unipd(dot)it> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | view table with foreign key relative values |
| Date: | 2011-05-10 11:49:04 |
| Message-ID: | 1305028144310-4384265.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hello List,
I have searched extensively for the following question:
Is it possible to view a table which has a column with a foreign key
constraint with the values of that column automatically substituted with the
corresponding values of the lookup table?
Or is the only way to make my own view and use a LEFT OUTER JOIN or such?
Probably a dumb question but I have not found any documentation on this (so
probably the latter is the case).
Cheers, and thanks for your time.
Francesco
--
View this message in context: http://postgresql.1045698.n5.nabble.com/view-table-with-foreign-key-relative-values-tp4384265p4384265.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ozer, Pam | 2011-05-10 15:07:41 | Re: Sorting Issue |
| Previous Message | Ozer, Pam | 2011-05-09 22:13:07 | Re: Sorting Issue |