From: Milen A. Radev <milen@radev.net>
To: pgsql-sql@postgresql.org
Subject: Re: CREATE TABLE
Date: Fri, 09 Mar 2007 16:05:41 +0200
Message-ID: <esrpjm$jnv$2@sea.gmane.org> (raw)
In-Reply-To: <00ed01c76252$b0bc28b0$1102a8c0@dream>
References: <00ed01c76252$b0bc28b0$1102a8c0@dream>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: milen@radev.net
Subject: Re: CREATE TABLE
In-Reply-To: <esrpjm$jnv$2@sea.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox