Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4A0D21337C27 for ; Tue, 10 May 2011 09:07:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 77894-03-5 for ; Tue, 10 May 2011 12:07:48 +0000 (UTC) X-Greylist: delayed 00:18:15.52714 by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id 683E61337C00 for ; Tue, 10 May 2011 09:07:20 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1QJlR2-0004rX-AU for pgsql-sql@postgresql.org; Tue, 10 May 2011 04:49:04 -0700 Date: Tue, 10 May 2011 04:49:04 -0700 (PDT) From: fpirotti To: pgsql-sql@postgresql.org Message-ID: <1305028144310-4384265.post@n5.nabble.com> Subject: view table with foreign key relative values MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.778 tagged_above=-5 required=5 tests=BAYES_00=-1.9, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201105/59 X-Sequence-Number: 35343 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.