X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 63BE2CBC3E for ; Mon, 14 Jul 2003 14:47:50 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 85398-06 for ; Mon, 14 Jul 2003 14:48:06 +0000 (GMT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id AC08DCBC33 for ; Mon, 14 Jul 2003 11:47:44 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6EEm8Q3001242; Mon, 14 Jul 2003 10:48:08 -0400 (EDT) To: Christoph Haller Cc: pgsql-interfaces@postgresql.org, adam@piggz.fsnet.co.uk Subject: Re: libpq:Find Table Name In-reply-to: <3F12981B.CDE42A4A@rodos.fzk.de> References: <3F12981B.CDE42A4A@rodos.fzk.de> Comments: In-reply-to Christoph Haller message dated "Mon, 14 Jul 2003 13:46:35 +0200" Date: Mon, 14 Jul 2003 10:48:08 -0400 Message-ID: <1241.1058194088@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/16 X-Sequence-Number: 4330 Christoph Haller writes: >> Has anyone any suggestions on how i can achieve getting the table name >> for a >> filed in a result without having to parse the sql statement (which i >> dont >> think wold be easy). >> > I very much doubt there is such thing, because the result may come from > a complex join or a function. There is support for this in PG 7.4, in the form of providing the table OID for a column (when it's determinable). regards, tom lane