Re: CREATE TABLE

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