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

From Reggie Burnett
Subject how do I get the table name from a query?
Date
Msg-id 00b001c2c610$ae084870$c600a8c0@endeavor
Whole thread Raw
Responses Re: how do I get the table name from a query?
List pgsql-hackers

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

pgsql-hackers by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Switching connection on the fly
Next
From: Tom Lane
Date:
Subject: Re: ECPG, threading and pooling