How to retrieve column names for tables with underscores

Hi,

this is probably more of a generic JDBC question, but since I'm trying to solve this with Postgres I'm posting it here:

I have two tables

table1_ (yes there is an underscore at the end)
table12

Now when I try to retrieve the columns for "table_" the columns of table12 are also returned because the table name parameter for DatabaseMetaData.getColumns() is used as a LIKE expression.

Is there a way (preferrably standard JDBC) to avoid the LIKE evaluation with the getColumns() call e.g. by specifying an escape character?. I tried to replace the underscore with the standard backslash escape ("table1\_") but that didn't work.

Or is the only reliable way to check the value of the returned TABLE_NAME whether it matches my input value?

Thanks
Thomas