Re: naming convention/mixed case

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alejandro Fernandez <ale(at)nin(dot)cx>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: naming convention/mixed case
Date: 2001-05-11 22:21:56
Message-ID: 7541.989619716@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alejandro Fernandez <ale(at)nin(dot)cx> writes:
> The problem is that postgres's handling of mixed case table names etc
> makes things quite complicated, as they have to be enclosed in double
> quotes:

Only if you insist on them appearing in mixed case in the database.
Have you thought about writing myFieldName in your queries, and ignoring
the fact that the database will smash it down to myfieldname?

> or is there a plan to get postgres naming to
> support mixed case more?

Doing so would make us less compliant with the SQL standard, so no,
there aren't any plans to change that.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-11 22:22:35 Re: Trigger only firing once
Previous Message Ed Loehr 2001-05-11 22:19:31 Re: microsecond log timestamps