From: | Rodrigo De León <rdeleonp(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it> |
Subject: | Re: CREATE TABLE |
Date: | 2007-03-09 14:09:01 |
Message-ID: | a55915760703090609v5f186e95ja0e4c9ec8a43420a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 3/9/07, Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Shavonne Marietta Wijesinghe | 2007-03-09 14:15:54 | Fw: CREATE TABLE |
Previous Message | Milen A. Radev | 2007-03-09 14:05:41 | Re: CREATE TABLE |