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
inlowercase :( 
 
> 
> 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