Re: Table Names

From: "Jules Alberts" <julesa(at)arbodienst-limburg(dot)nl>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Table Names
Date: 2002-01-25 11:20:11
Message-ID: 200201251125.g0PBPuLs012302@artemis.cuci.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Boyle (Roselink) 2002-01-25 11:40:21 Re: Table Names
Previous Message Oliver Elphick 2002-01-25 11:16:30 Re: Table Names