| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: How to retrieve column names for tables with underscores |
| Date: | 2011-03-24 21:41:58 |
| Message-ID: | imgdqv$3vu$1@dough.gmane.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Maciek Sakrejda wrote on 24.03.2011 22:02:
>> Interesting enough, the setting of standard_conforming_strings does not seem
>> to affect this at all. Am I missing something?
>
> Doesn't seem to affect what, exactly?
The escape character returned by getSearchStringEscape()
>It definitely affects how
> backslashes are interpreted, and unless the current version of the
> JDBC driver injects the 'E' escape syntax (with the 'E' prefix,
> backslash escape sequences are interpreted regardless of the setting)
> in a cavalier manner into the LIKE expression comparisons for
> getColumns() (the one I have handy doesn't seem to), you should see
> different behavior.
Regardless of the setting of standard_conforming_strings passing \_ to getColumns() always works properly.
See Kris' answer for details.
Regards
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Johnston | 2011-03-24 22:52:27 | Re: How to retrieve column names for tables with underscores |
| Previous Message | Kris Jurka | 2011-03-24 21:10:29 | Re: How to retrieve column names for tables with underscores |