pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
about uppercase
3+ messages / 3 participants
[nested] [flat]

* about uppercase
@ 2004-12-28 03:14 Leo Liou <lioul@hotmail.com>
  2004-12-29 03:31 ` Re: about uppercase Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Leo Liou @ 2004-12-28 03:14 UTC (permalink / raw)
  To: pgsql-admin

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.

Thank you very much in advance.





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: about uppercase
  2004-12-28 03:14 about uppercase Leo Liou <lioul@hotmail.com>
@ 2004-12-29 03:31 ` Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Robert Treat @ 2004-12-29 03:31 UTC (permalink / raw)
  To: Leo Liou <lioul@hotmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: about uppercase
@ 2004-12-29 04:01 Goulet, Dick <DGoulet@vicr.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Goulet, Dick @ 2004-12-29 04:01 UTC (permalink / raw)
  To: Robert Treat <xzilla@users.sourceforge.net>; Leo Liou <lioul@hotmail.com>; +Cc: pgsql-admin

As far as I'm concerned I really don't care so long as the DBMS is
consistent on the matter.  Both Oracle & PostGreSql do that. 


Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Robert Treat [mailto:xzilla@users.sourceforge.net] 
Sent: Tuesday, December 28, 2004 10:31 PM
To: Leo Liou
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] about uppercase

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-12-29 04:01 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-28 03:14 about uppercase Leo Liou <lioul@hotmail.com>
2004-12-29 03:31 ` Robert Treat <xzilla@users.sourceforge.net>
2004-12-29 04:01 Re: about uppercase Goulet, Dick <DGoulet@vicr.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox