| Lists: | pgsql-odbc |
|---|
| From: | lothar(dot)behrens(at)lollisoft(dot)de |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Best way of retrieving tablename from a query ? |
| Date: | 2005-07-20 16:54:11 |
| Message-ID: | 42DE9DD3.20754.1D00D1@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
Hi,
my last question seems to be overseen.
Isn't there a good way to get the table name from a given SQL query
without inspecting the query it self ?
My last try to use SQLColumns was partially usable. It returned a table
name, but it does not stay in relation to my query.
Thanks
Lothar
--
Lothar Behrens | Rapid Prototyping ...
Rosmarinstr 3 |
40235 Düsseldorf | www.lollisoft.de
| From: | lothar(dot)behrens(at)lollisoft(dot)de |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Best way of retrieving tablename from a query ? |
| Date: | 2005-07-20 18:11:34 |
| Message-ID: | 42DEAFF6.14760.63D877@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
Hi,
now I have found the function for this requirement.
SQLColAttribute with SQL_DESC_BASE_TABLE_NAME as the third parameter
gives me what I need.
Lothar
--
Lothar Behrens | Rapid Prototyping ...
Rosmarinstr 3 |
40235 Düsseldorf | www.lollisoft.de