How to retrieve column names for tables with underscores - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject How to retrieve column names for tables with underscores
Date
Msg-id imfg0q$481$1@dough.gmane.org
Whole thread Raw
Responses Re: How to retrieve column names for tables with underscores
List pgsql-jdbc
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
parameterfor 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
anescape 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

pgsql-jdbc by date:

Previous
From: sdavidr
Date:
Subject: Problems with Hibernate Discriminators and 9.0-801.jdbc4
Next
From: "ml-tb"
Date:
Subject: Re: How to retrieve column names for tables with underscores