Skip site navigation (1) Skip section navigation (2)

ODBC case sensitive table names?

From: eg(at)tzv(dot)fal(dot)de
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC case sensitive table names?
Date: 2000-06-21 09:19:44
Message-ID: (view raw or whole thread)
Lists: 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

Eildert Groeneveld
Institute for
Animal Science and Animal Behaviour
Mariensee 31535 Neustadt Germany
Tel   : (49)(0)5034 871155
Fax   : (49)(0)5034 92579
www   : 
e-mail: eg(at)tzv(dot)fal(dot)de

pgsql-interfaces by date

Next:From: Tibor LaszloDate: 2000-06-21 16:42:57
Subject: Re:
Previous:From: Jim CaleyDate: 2000-06-20 21:39:32
Subject: Re: Postgres JDBC driver : problem with timestamps.

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group