Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group