From: Rodrigo De León <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org
Cc: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
Subject: Re: CREATE TABLE
Date: Fri, 9 Mar 2007 09:09:01 -0500
Message-ID: <a55915760703090609v5f186e95ja0e4c9ec8a43420a@mail.gmail.com> (raw)
In-Reply-To: <00ed01c76252$b0bc28b0$1102a8c0@dream>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rdeleonp@gmail.com, shavonne.marietta@studioform.it
Subject: Re: CREATE TABLE
In-Reply-To: <a55915760703090609v5f186e95ja0e4c9ec8a43420a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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