X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 84F4A3A6200 for ; Wed, 29 Dec 2004 03:35:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79834-06 for ; Wed, 29 Dec 2004 03:35:13 +0000 (GMT) Received: from lakermmtao03.cox.net (lakermmtao03.cox.net [68.230.240.36]) by svr1.postgresql.org (Postfix) with ESMTP id DB48B3AC055 for ; Wed, 29 Dec 2004 03:35:05 +0000 (GMT) Received: from [192.168.0.8] (really [68.226.6.80]) by lakermmtao03.cox.net (InterMail vM.6.01.04.00 201-2131-117-20041022) with ESMTP id <20041229033504.UYRZ2250.lakermmtao03.cox.net@[192.168.0.8]>; Tue, 28 Dec 2004 22:35:04 -0500 From: Robert Treat To: "Leo Liou" Subject: Re: about uppercase Date: Tue, 28 Dec 2004 22:31:13 -0500 User-Agent: KMail/1.6.2 Cc: pgsql-admin@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit Message-Id: <200412282231.13463.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/262 X-Sequence-Number: 15848 On Monday 27 December 2004 22:14, Leo Liou wrote: > Hello, I'm a newbie at using Postgresql. > I have a huge problem at using uppercase and lowercase. > > My question is if there is any possible way to set > my Postgresql7.4.3 to uppercase? > I mean if it's possible to set the DB server so that when i > create a new table without double-quote at tablename and > column name, i get a table with uppercase tablename and > column name. > I'm using Postgresql7.4.3 at WinXP SP1. > The short answer is no, you'll have to double quote or live with lower casing. The longer answer is that it is possible to hack the source code and then recompile it, however no one has ever claimed to have run such a change in any type of production system and there are several theories about things that would break under such a configuration. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL