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

Re: Table Names

From: "Steve Boyle \(Roselink\)" <boylesa(at)roselink(dot)co(dot)uk>
To: "Rob" <rob(at)obsidian(dot)co(dot)za>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Table Names
Date: 2002-01-25 11:40:21
Message-ID: 002101c1a595$122f1470$c55869d5@dualtower (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

Search Google for 'postgres case sensitivity' for loads of links re this.

(in summary to keep case sensitivity use double quotes for object names in
your SQL)


steve boyle
----- Original Message -----
From: "Rob" <rob(at)obsidian(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Friday, January 25, 2002 4:08 PM
Subject: [NOVICE] Table Names

> 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?
> Thanks
> Rob
> --
> He who dies with the most toys ...
> ... still dies
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

pgsql-novice by date

Next:From: denisDate: 2002-01-25 12:31:30
Subject: Email on Commit
Previous:From: Jules AlbertsDate: 2002-01-25 11:20:11
Subject: Re: Table Names

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