Thread: Fw: CREATE TABLE

Fw: CREATE TABLE

From
"Shavonne Marietta Wijesinghe"
Date:
The problem i'm having is i can't pass them in the strSQL string. coz when i 
write " i close the string :\


Shavonne Wijesinghe
http://www.studioform.it


Le informazioni contenute nella presente comunicazione e i relativi allegati 
possono essere riservate e sono, comunque destinate esclusivamente alle 
persone o alla Società sopra indicati.
La diffusione, distribuzione e/o copiature del documento trasmesso da parte 
di qualsiasi soggetto diverso dal destinatario è proibita, sia ai sensi dell'art. 
616 c.p., che ai sensi del D. Lgs. n. 196/2003.

Se avete ricevuto questo messaggio per errore, Vi preghiamo di distruggerlo 
e di informarci immediatamente per telefono allo 0039362595044 o inviando un 
messaggio all'indirizzo e-mail
amministrazione@studioform.it

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
----- Original Message ----- 
From: "Rodrigo De León" <rdeleonp@gmail.com>
To: <pgsql-sql@postgresql.org>
Cc: "Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>
Sent: Friday, March 09, 2007 3:09 PM
Subject: Re: [SQL] 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. 



Re: Fw: CREATE TABLE

From
Andrew Sullivan
Date:
On Fri, Mar 09, 2007 at 03:15:54PM +0100, Shavonne Marietta Wijesinghe wrote:
> The problem i'm having is i can't pass them in the strSQL string. coz when 
> i write " i close the string :\

You likely need to escape the double-quotes.  How you do it in your
environment is a topic for the manuals for that environment.  

A


-- 
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.    --H.W. Fowler