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 AD4ADCC127 for ; Mon, 14 Jul 2003 19:00:18 +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 40344-09 for ; Mon, 14 Jul 2003 19:00:29 +0000 (GMT) Received: from mail.iskon.hr (mail.iskon.hr [213.191.128.4]) by svr1.postgresql.org (Postfix) with SMTP id EF836CC126 for ; Mon, 14 Jul 2003 16:00:02 -0300 (ADT) Received: (qmail 20692 invoked from network); 14 Jul 2003 21:00:26 +0200 Received: from zg07-208.dialin.iskon.hr (HELO darko) (213.191.150.209) by mail.iskon.hr with SMTP; 14 Jul 2003 21:00:26 +0200 Message-ID: <004001c34971$dc4b4b80$d196bfd5@darko> From: "Darko Prenosil" To: References: <3F12981B.CDE42A4A@rodos.fzk.de> <1241.1058194088@sss.pgh.pa.us> Subject: Re: libpq:Find Table Name Date: Sun, 13 Jul 2003 21:06:06 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/17 X-Sequence-Number: 4331 ----- Original Message ----- From: "Tom Lane" To: "Christoph Haller" Cc: ; Sent: Monday, July 14, 2003 4:48 PM Subject: Re: [INTERFACES] libpq:Find Table Name > 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). > Wow !!! I should read changelogs more often ! Regards !