|
Hi Postgre I am
having trouble with PostgreSQL’s implementation of
DataBaseMetaData.getTables()
and looking at the code I found this comment and so I am writing to
you. The
problem I am having is that If I create tables with
uppercase letters like this create table
“FOO” ( “NUM” numeric
); then I can�t use this code to check if the table
exists ResultSet rs = conn.getMetaData().getTables( null, null, “FOO”, null
); Boolean
exists = rs.next(); I suppose
it�s because the tableNamePattern is being converted toLowerCase()
// Added by Stefan Andreasen
<[EMAIL PROTECTED]>
// Now take the pattern into account
sql.append(") and relname like
'");
sql.append(tableNamePattern.toLowerCase());
sql.append("' order by relkind, relname"); I suggest
to eliminate this conversion and leave the user do the conversion if he
desires. Greetings Ricardo
Andr�s Capurro Senior
Software Developer ATS
Advanced Technology Solutions S.A. Av. Corrientes
880 Piso 11 (C1043AAV)
Buenos Aires Argentina Tel:
+54-11-6393-4345 +54-11-4393-4345 Fax:
+54-11-6393-4300 e-mail laboral:
mailto:[EMAIL PROTECTED] e-mail
personal: mailto:[EMAIL PROTECTED] ICQ#: 103449056 |
Title: Message
