Re: How to retrieve column names for tables with underscores

From: Kris Jurka <books(at)ejurka(dot)com>
To: ml-tb <ml-tb(at)emagixx(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: How to retrieve column names for tables with underscores
Date: 2011-03-24 20:18:17
Message-ID: alpine.BSO.2.00.1103241615460.4390@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Kellerer 2011-03-24 20:45:13 Re: How to retrieve column names for tables with underscores
Previous Message ml-tb 2011-03-24 15:18:31 Re: How to retrieve column names for tables with underscores