From: Franz J Fortuny <ffortuny@ivsol.com>
To: pgsql-sql@postgresql.org
Subject: Upper case or lower case....
Date: Mon, 21 Aug 2000 12:49:40 -0500
Message-ID: <1%do5.45130$2k1.1270655@news-west.usenetserver.com> (raw)
This statement:
create table tabname
(
field1 integer,
field2 integer
);
creates a table with tablename "tabname", lower case or IRRELEVANT
CASE?
Also, field1 is "field1" (all lower case) or is it case irrelevant?
The problem we are having is that those queries we have working for
our commercial database, create, at the commercial database, a table
with name "TABNAME", and the fields are "FIELD1" and "FIELD2".
If you use C++ Builder from Borland/Inprise, you will notice that
the column names come in lower case when the origing is a postgreSQL
database, and in UPPER CASE when the database is the commercial one
we are using.
Is there a way to configure the behavior of PostgreSQL so that it
will not consider case relevant anything that goes without quotes?
All of the commercial products return UPPER CASE (with the the
borland/inprice c++ 5 tool). Only PostgreSQL returns lower case
names for the columns. This really means a serious drawback for
programmers:
This code,
qQuery1COLUMNSO->AsInteger...
is automatically created by the builder when the column names are
retrieved from the database, if the database is a commercial one. If
it is PostgreSQL, it returns this:
qQuery1columnso->AsInteger...
As this can be very easily seen, it doesn't help in making things
easy when one is intending to develop applications that should run
against any SQL Server. I have been trying to find ways to make
PostgreSQL apply the policy of giving out always upper case names,
but I have not been able to find this. It is a hassle to have to
transform all the queries which were "select col,col2,col3 from
tabname" to "select "COL","COL2","COL3" from "TABNAME" " An
unthinkable job.
Any suggestions?
Franz J Fortuny
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: ffortuny@ivsol.com
Subject: Re: Upper case or lower case....
In-Reply-To: <1%do5.45130$2k1.1270655@news-west.usenetserver.com>
References: <1%do5.45130$2k1.1270655@news-west.usenetserver.com>
* 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