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