Re: How to retrieve column names for tables with underscores

On Thu, 24 Mar 2011, ml-tb wrote:

> Hi Thomas,
>
> Am Donnerstag, 24. M?rz 2011 schrieb Thomas Kellerer:
>> backslash escape ("table1\_") but that didn't work.
> IMHO it should be "table1\\_"?
>

The escape needed depends on the value of standard_conforming_strings.
You should use this call to find the escape needed:

http://download.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getSearchStringEscape()

Kris Jurka