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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
