[HACKERS] how do I get the table name from a query?

2003-01-27 Thread Reggie Burnett
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

Re: [HACKERS] how do I get the table name from a query?

2003-01-27 Thread Reggie Burnett
table name, I would have to parse this myself? Reggie -Original Message- From: [EMAIL PROTECTED] [mailto:pgsql-hackers- [EMAIL PROTECTED]] On Behalf Of Dave Cramer Sent: Monday, January 27, 2003 8:42 AM To: Reggie Burnett Cc: 'Hackers' Subject: Re: [HACKERS] how do I get the table