From: | "Milen A(dot) Radev" <milen(at)radev(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: CREATE TABLE |
Date: | 2007-03-09 14:05:41 |
Message-ID: | esrpjm$jnv$2@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Shavonne Marietta Wijesinghe 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) ?
>
You should quote the name. Please read more about it here -
http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
Excerpt: "Quoting an identifier also makes it case-sensitive, whereas
unquoted names are always folded to lower case."
--
Milen A. Radev
From | Date | Subject | |
---|---|---|---|
Next Message | Rodrigo De León | 2007-03-09 14:09:01 | Re: CREATE TABLE |
Previous Message | Shavonne Marietta Wijesinghe | 2007-03-09 13:56:06 | CREATE TABLE |