DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=RfeU3uiypvGn5kVgk/h2auipa9PKnUDsmou+s38u+q1oUw+ESKVGUClko8byCkH86wabkAEs5aozVt5sWoCDnRWB1GiYZYr+m9sMucCvV5xd80icwU6gboJ7BFyFo3oty5PFvIZjJf2SWsgmaVZMnOXfsuSm0iKH81UQDftE4/0=
Message-ID: <a55915760703090609v5f186e95ja0e4c9ec8a43420a@mail.gmail.com>
Date: Fri, 9 Mar 2007 09:09:01 -0500
From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: CREATE TABLE
Cc: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
In-Reply-To: <00ed01c76252$b0bc28b0$1102a8c0@dream>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <00ed01c76252$b0bc28b0$1102a8c0@dream>

On 3/9/07, Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it> wrote:
> Hello
>
> From my asp page i create a table
>
> TableName = "CON01"
> strSQL = "CREATE TABLE " & TableName & " ( ID text, N_GEN serial     not
> null);"
>
> But the problem i have is that when i go and open my database in pgadmin the
> table name and coloumn name is written in lowercase :(
>
> How do i ask it to write them in uppercase (like in my strSQL) ?
>
> Thanks
>
> Shavonne Wijesinghe
> http://www.studioform.it

Quote them.

See:
http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

> The informations in this communication is confidential and may also be
> legally privileged. It is intended for the addressee only.
> Access to this e-mail by anyone else is unauthorized. It is not to be relied
> upon by any person other than the addressee, except with our prior written
> approval. If you received this message please send an e-mail to the se

Please, lose the legaleze filler. If not possible for you, a
workaround is to use a public email service to send emails to the
list.