Re: Bringing PostgreSQL torwards the standard regarding

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Shachar Shemesh <psql(at)shemesh(dot)biz>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: Bringing PostgreSQL torwards the standard regarding
Date: 2004-04-25 16:08:30
Message-ID: 1082909309.6544.81.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> I'm not sure you understood me.

Perhaps not, here is what we have:

\c template_db
CREATE TABLE "example" ( "col" integer);

CREATE DATABASE newdb WITH TEMPLATE template_db UPPERCASE IDENTIFIERS;

\c newdb
SELECT "col" FROM "example";

> In short, I don't think this suggestion broke your database.

I understood that since "example", when copied, would turn into
"EXAMPLE" -- but that if it was "Example" it would be copied as
"Example".

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-04-25 16:23:55 Re: Bringing PostgreSQL torwards the standard regarding
Previous Message Shachar Shemesh 2004-04-25 16:03:17 Re: Bringing PostgreSQL torwards the standard regarding