ODBC case sensitive table names? - Mailing list pgsql-interfaces

From eg@tzv.fal.de
Subject ODBC case sensitive table names?
Date
Msg-id XFMail.20000621111944.eg@tzv.fal.de
Whole thread Raw
List pgsql-interfaces
Hello everyone,
in the process of migrating a VB (Windows) application with access to
PostgreSQL/Linux we ran across the problem of case sensitive Column names:

select * from SomeTable;

works fine with psql

but when sent via ODBC we get an 'illegal tablename' back.
as many table names start with a capital letter in VB we would hate to
convert them manually.

Any ideas?

Postgresql 7.0.1
ODBC 6.5
WIN NT

Eildert Groeneveld
=========================================
Institute for
Animal Science and Animal Behaviour
Mariensee 31535 Neustadt Germany
Tel   : (49)(0)5034 871155
Fax   : (49)(0)5034 92579
www   : http://www.tzv.fal.de/~eg/ 
e-mail: eg@tzv.fal.de
=========================================


pgsql-interfaces by date:

Previous
From: Jim Caley
Date:
Subject: Re: Postgres JDBC driver : problem with timestamps.
Next
From: Tibor Laszlo
Date:
Subject: Re: