From: markh@clockworkweb.com
To: pgsql-interfaces@postgresql.org
Subject: Case problems in table and column names
Date: Wed, 18 Nov 1998 17:22:29 GMT
Message-ID: <365afb40.453473870@jupiter.munster> (raw)
It is my understanding that the case of tables and column names should not
be significant, and if you use the 'psql' front end it turns all table and
column names into lower case.
I like to use UpperAndLower case names so that table and column names are
readable. What I have done today is to create a DB on my laptop in
Microsoft Access then when I was in the office I exported the tables via
ODBC into a Postgres database.
The ODBC driver is preserving case, so the tables and columns are being
created in UpperAndLower case. Now if I access the database from 'psql' or
use 'pg_dump -d database > file' it all falls apart, because 'psql'
converts all table and column names to lower case and then can't find
them.
Should the ODBC driver be doing the translation to lower case?
I'm using ODBC driver 6.40.0001 with Postgres 6.3.2 from RedHat 5.1.
--
Mark Himsley.
Technical Director
Clockwork Web.
+44 171 471 0770
http://www.clockworkweb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: markh@clockworkweb.com
Subject: Re: Case problems in table and column names
In-Reply-To: <365afb40.453473870@jupiter.munster>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox