Re: Table Names - Mailing list pgsql-novice

From Jules Alberts
Subject Re: Table Names
Date
Msg-id 200201251125.g0PBPuLs012302@artemis.cuci.nl
Whole thread Raw
In response to Table Names  (Rob <rob@obsidian.co.za>)
List pgsql-novice
On 25 Jan 2002 at 11:08, Rob wrote:
> I have a table name SYS_Keyword, but everytime I try to query it,
> postgres converts it to sys_keyword and then can't find it.  Why does it
> do this and is there any way around it?

AFAIK postgresql is case-insensitive and works internally with
lowercase characters. you could use double quotes but for table names,
that way the uppercase remains, but you would have to use the quotes
every time you use the table name.

--
Jules Alberts.

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Table Names
Next
From: denis@coralindia.com
Date:
Subject: Email on Commit