Re: CREATE TABLE

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.