Re: how do I get the table name from a query? - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: how do I get the table name from a query?
Date
Msg-id 1043678503.1085.19.camel@inspiron.cramers
Whole thread Raw
In response to how do I get the table name from a query?  ("Reggie Burnett" <rykr@bellsouth.net>)
Responses Re: how do I get the table name from a query?
List pgsql-hackers
Reggie,

At the moment, you can't, but please comment on my request for qualified
column names. This is the same issue and there are many collateral
issues which Tom has brought up.

Dave
On Mon, 2003-01-27 at 09:30, Reggie Burnett wrote:
> When using the FE/BE, how do I retrieve the table name for a given
> column?  Say I had the following SQL:
> 
>  
> 
> Select c.id, c.name, d.phone from Members c, Addresses d where c.id <
> 200
> 
>  
> 
> From the docs of the FE/BE, I would see that the fields are named id,
> name, phone but how do I find out the source tables that each field
> came from?  I need to know this to discover nullability of fields,
> uniqueness, etc.
> 
>  
> 
> Thanks
> 
> Reggie
-- 
Dave Cramer <dave@fastcrypt.com>
Cramer Consulting



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ECPG, threading and pooling
Next
From: Tom Lane
Date:
Subject: Re: help with I/O statistics in 7.3.1