pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCREATE TABLE
17+ messages / 13 participants
[nested] [flat]
* CREATE TABLE
@ 1999-02-25 13:06 Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.co>
0 siblings, 0 replies; 17+ messages in thread
From: Ingrith Andrea Correa Vargas @ 1999-02-25 13:06 UTC (permalink / raw)
To: pgsql-sql
Hello!
I have a question:
I want to create a table with a column wich will have a DEFAULT
user-function value.
Can you write an example, with the right syntax?!
I have been making some examples, but I always have a syntax error that I
can't solve.
Thank you in advance, and I'll be waiting for a response!
// Ingrith :)
^ permalink raw reply [nested|flat] 17+ messages in thread
* CREATE TABLE
@ 1999-02-25 18:56 Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.co>
1999-02-26 07:25 ` Re: [SQL] CREATE TABLE Remigiusz Sokolowski <rems@gdansk.sprint.pl>
1999-02-26 20:51 ` Re: [SQL] CREATE TABLE David Martinez Cuevas <david@estadistica.unam.mx>
0 siblings, 2 replies; 17+ messages in thread
From: Ingrith Andrea Correa Vargas @ 1999-02-25 18:56 UTC (permalink / raw)
To: pgsql-sql
Hello!
I have a question:
I want to create a table with a column wich will have a DEFAULT
user-function value.
Can you write an example, with the right syntax?!
I have been making some examples, but I always have a syntax error that I
can't solve.
Thank you in advance, and I'll be waiting for a response!
// Ingrith :)
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: [SQL] CREATE TABLE
1999-02-25 18:56 CREATE TABLE Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.co>
@ 1999-02-26 07:25 ` Remigiusz Sokolowski <rems@gdansk.sprint.pl>
1 sibling, 0 replies; 17+ messages in thread
From: Remigiusz Sokolowski @ 1999-02-26 07:25 UTC (permalink / raw)
To: Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.co>; +Cc: pgsql-sql
>
> I want to create a table with a column wich will have a DEFAULT
> user-function value.
> Can you write an example, with the right syntax?!
>
> I have been making some examples, but I always have a syntax error that I
> can't solve.
>
> Thank you in advance, and I'll be waiting for a response!
It could be something like:
create table test(
test_id int4 default nextval('test_seq'),
test_txt text
);
Regards
Rem
-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * *
-----------------------------------------------------------------*****----------
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: [SQL] CREATE TABLE
1999-02-25 18:56 CREATE TABLE Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.co>
@ 1999-02-26 20:51 ` David Martinez Cuevas <david@estadistica.unam.mx>
1 sibling, 0 replies; 17+ messages in thread
From: David Martinez Cuevas @ 1999-02-26 20:51 UTC (permalink / raw)
To: Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.co>; +Cc: pgsql-sql
On Thu, 25 Feb 1999, Ingrith Andrea Correa Vargas wrote:
>
> Hello!
Hola Ingrith
>
> I have a question:
>
> I want to create a table with a column wich will have a DEFAULT
> user-function value.
> Can you write an example, with the right syntax?!
>
> I have been making some examples, but I always have a syntax error that I
> can't solve.
>
> Thank you in advance, and I'll be waiting for a response!
This an example of what you want
create sequence seq_master;
create table master ( id int default (nextval('seq_master')));
Obviously, 'nextval' is not a user defined function, but i guess you can
use one of yours.
NOTICE: I'm using PGSQL 6.3-2
Suerte.
David Martinez Cuevas
Office 622-60-72 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Home 565-25-17 "Eat Linux, Drink Linux... SMOKE LINUX "
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
^ permalink raw reply [nested|flat] 17+ messages in thread
* create table
@ 2001-04-29 19:34 LeoDeBeo <leodebeo@hotmail.com>
2001-05-04 16:17 ` Re: create table Martín Marqués <martin@bugs.unl.edu.ar>
2001-05-04 21:38 ` Re: create table Joel Burton <jburton@scw.org>
2001-05-04 22:43 ` Re: create table Tom Lane <tgl@sss.pgh.pa.us>
2001-05-05 16:32 ` Re: create table Albert REINER <areiner@tph.tuwien.ac.at>
0 siblings, 4 replies; 17+ messages in thread
From: LeoDeBeo @ 2001-04-29 19:34 UTC (permalink / raw)
To: pgsql-sql
can anybody explain me the syntax of Create Table documentation??
CREATE [ TEMPORARY | TEMP ] TABLE table (
column type
[ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
[ column_constraint_clause | PRIMARY KEY } [ ... ] ]
[ , ... ]
[ , PRIMARY KEY ( column [, ... ] ) ]
[ , CHECK (condition) ]
[ , table_constraint_clause ]
) [ INHERITS ( inherited_table [, ... ] ) ]
i don't understand what the curly brace means after PRIMARY KEY (where is
the other matching brace? ). It must have something to do with the fact
that a 'column type' pair ( with options ) can occur more than once, but is
this syntax right?
i also don't understand what the [ ... ] and [, ... ] means. I do know that
brackets denote options and | alternatives.
tx
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: create table
2001-04-29 19:34 create table LeoDeBeo <leodebeo@hotmail.com>
@ 2001-05-04 16:17 ` Martín Marqués <martin@bugs.unl.edu.ar>
3 siblings, 0 replies; 17+ messages in thread
From: Martín Marqués @ 2001-05-04 16:17 UTC (permalink / raw)
To: LeoDeBeo <leodebeo@hotmail.com>; pgsql-sql
On Dom 29 Abr 2001 22:34, LeoDeBeo wrote:
> can anybody explain me the syntax of Create Table documentation??
>
> CREATE [ TEMPORARY | TEMP ] TABLE table (
> column type
> [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
> [ column_constraint_clause | PRIMARY KEY } [ ... ] ]
> [ , ... ]
> [ , PRIMARY KEY ( column [, ... ] ) ]
> [ , CHECK (condition) ]
> [ , table_constraint_clause ]
> ) [ INHERITS ( inherited_table [, ... ] ) ]
>
> i don't understand what the curly brace means after PRIMARY KEY (where is
> the other matching brace? ). It must have something to do with the fact
> that a 'column type' pair ( with options ) can occur more than once, but is
> this syntax right?
> i also don't understand what the [ ... ] and [, ... ] means. I do know that
> brackets denote options and | alternatives.
My docs (7.1) look like this:
CREATE [ TEMPORARY | TEMP ] TABLE table_name (
{ column_name type [ column_constraint [ ... ] ]
| table_constraint } [, ... ]
) [ INHERITS ( inherited_table [, ... ] ) ]
where column_constraint can be:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | UNIQUE | PRIMARY KEY | DEFAULT value | CHECK (condition) |
REFERENCES table [ ( column ) ] [ MATCH FULL | MATCH PARTIAL ]
[ ON DELETE action ] [ ON UPDATE action ]
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE
]
}
and table_constraint can be:
[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
PRIMARY KEY ( column_name [, ... ] ) |
CHECK ( condition ) |
FOREIGN KEY ( column_name [, ... ] ) REFERENCES table [ ( column [, ... ] )
]
[ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ]
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE
]
}
Looks clear to me. :-)
--
El mejor sistema operativo es aquel que te da de comer.
Cuida tu dieta.
-----------------------------------------------------------------
Martin Marques | mmarques@unl.edu.ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: create table
2001-04-29 19:34 create table LeoDeBeo <leodebeo@hotmail.com>
@ 2001-05-04 21:38 ` Joel Burton <jburton@scw.org>
3 siblings, 0 replies; 17+ messages in thread
From: Joel Burton @ 2001-05-04 21:38 UTC (permalink / raw)
To: LeoDeBeo <leodebeo@hotmail.com>; +Cc: pgsql-sql
On Sun, 29 Apr 2001, LeoDeBeo wrote:
> can anybody explain me the syntax of Create Table documentation??
This doc is much improved in the more recent PG create table help.
Check out the online 7.1 Reference Manual, and there's a much nicer CREATE
TABLE grammar.
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: create table
2001-04-29 19:34 create table LeoDeBeo <leodebeo@hotmail.com>
@ 2001-05-04 22:43 ` Tom Lane <tgl@sss.pgh.pa.us>
3 siblings, 0 replies; 17+ messages in thread
From: Tom Lane @ 2001-05-04 22:43 UTC (permalink / raw)
To: LeoDeBeo <leodebeo@hotmail.com>; +Cc: pgsql-sql
LeoDeBeo <leodebeo@hotmail.com> writes:
> i don't understand what the curly brace means after PRIMARY KEY (where is
> the other matching brace?
Typo. Try more recent versions of the docs. 7.1 says
CREATE [ TEMPORARY | TEMP ] TABLE table_name (
{ column_name type [ column_constraint [ ... ] ]
| table_constraint } [, ... ]
) [ INHERITS ( inherited_table [, ... ] ) ]
where column_constraint can be:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | UNIQUE | PRIMARY KEY | DEFAULT value | CHECK (condition) |
REFERENCES table [ ( column ) ] [ MATCH FULL | MATCH PARTIAL ]
[ ON DELETE action ] [ ON UPDATE action ]
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
}
and table_constraint can be:
[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
PRIMARY KEY ( column_name [, ... ] ) |
CHECK ( condition ) |
FOREIGN KEY ( column_name [, ... ] ) REFERENCES table [ ( column [, ... ] ) ]
[ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ]
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
}
The curly braces are just for grouping in cases where it'd not be clear
how far the alternatives are supposed to extend.
regards, tom lane
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: create table
2001-04-29 19:34 create table LeoDeBeo <leodebeo@hotmail.com>
@ 2001-05-05 16:32 ` Albert REINER <areiner@tph.tuwien.ac.at>
3 siblings, 0 replies; 17+ messages in thread
From: Albert REINER @ 2001-05-05 16:32 UTC (permalink / raw)
To: pgsql-sql
On Sun, Apr 29, 2001 at 09:34:29PM +0200, LeoDeBeo wrote:
> can anybody explain me the syntax of Create Table documentation??
...
> i also don't understand what the [ ... ] and [, ... ] means. I do know that
> brackets denote options and | alternatives.
I guess:
``[ ... ]'' means that you may repeat the clause, and
``[, ... ]'' means that you may repeat the clause, using a comma for separation
Albert.
^ permalink raw reply [nested|flat] 17+ messages in thread
* CREATE TABLE
@ 2007-03-09 13:56 Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
2007-03-09 14:05 ` Re: CREATE TABLE Milen A. Radev <milen@radev.net>
2007-03-09 14:09 ` Re: CREATE TABLE Rodrigo De León <rdeleonp@gmail.com>
2007-03-09 14:21 ` Re: CREATE TABLE Andrew Sullivan <ajs@crankycanuck.ca>
2007-03-09 14:37 ` Re: CREATE TABLE Bart Degryse <Bart.Degryse@indicator.be>
0 siblings, 4 replies; 17+ messages in thread
From: Shavonne Marietta Wijesinghe @ 2007-03-09 13:56 UTC (permalink / raw)
To: pgsql-sql
Hello
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: CREATE TABLE
2007-03-09 13:56 CREATE TABLE Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
@ 2007-03-09 14:05 ` Milen A. Radev <milen@radev.net>
3 siblings, 0 replies; 17+ messages in thread
From: Milen A. Radev @ 2007-03-09 14:05 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: CREATE TABLE
2007-03-09 13:56 CREATE TABLE Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
@ 2007-03-09 14:09 ` Rodrigo De León <rdeleonp@gmail.com>
3 siblings, 0 replies; 17+ messages in thread
From: Rodrigo De León @ 2007-03-09 14:09 UTC (permalink / raw)
To: pgsql-sql; +Cc: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
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.
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: CREATE TABLE
2007-03-09 13:56 CREATE TABLE Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
@ 2007-03-09 14:21 ` Andrew Sullivan <ajs@crankycanuck.ca>
3 siblings, 0 replies; 17+ messages in thread
From: Andrew Sullivan @ 2007-03-09 14:21 UTC (permalink / raw)
To: pgsql-sql
On Fri, Mar 09, 2007 at 02:56:06PM +0100, Shavonne Marietta Wijesinghe wrote:
>
> 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 :(
Unquoted identifiers in PostgreSQL are folded to lower case. This is
contrary to the SQL spec, but it normally doesn't matter because the
rule is applied consistently.
Therefore, you have two possibilities:
1. _Never_ quote identifiers. If you do it this way, everything
will always be folded to lower case, so your queries will always work
correctly.
2. _Always_ quote identifiers. This way, you always get upper
case, or mixed case, or lower case, or whatever. Indeed, you can
actually have two tables named "mytable" and "MyTable" this way, if
you were so inclined/completely mad.
The important thing to remember is that you have to pick one style,
and be absolutely certain to use it consistently. If you mix the
styles, you'll get surprises.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: CREATE TABLE
2007-03-09 13:56 CREATE TABLE Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
@ 2007-03-09 14:37 ` Bart Degryse <Bart.Degryse@indicator.be>
3 siblings, 0 replies; 17+ messages in thread
From: Bart Degryse @ 2007-03-09 14:37 UTC (permalink / raw)
To: pgsql-sql
Because being consistent is easily overlooked I would advise not to quote the table names
Instead of calling your table thisTableIsBig call it this_table_is_big
>>> Andrew Sullivan <ajs@crankycanuck.ca> 2007-03-09 15:21 >>>
On Fri, Mar 09, 2007 at 02:56:06PM +0100, Shavonne Marietta Wijesinghe wrote:
>
> 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 :(
Unquoted identifiers in PostgreSQL are folded to lower case. This is
contrary to the SQL spec, but it normally doesn't matter because the
rule is applied consistently.
Therefore, you have two possibilities:
1._Never_ quote identifiers. If you do it this way, everything
will always be folded to lower case, so your queries will always work
correctly.
2._Always_ quote identifiers. This way, you always get upper
case, or mixed case, or lower case, or whatever. Indeed, you can
actually have two tables named "mytable" and "MyTable" this way, if
you were so inclined/completely mad.
The important thing to remember is that you have to pick one style,
and be absolutely certain to use it consistently. If you mix the
styles, you'll get surprises.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 17+ messages in thread
* Fw: CREATE TABLE
@ 2007-03-09 14:15 Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
2007-03-09 14:22 ` Re: Fw: CREATE TABLE Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 17+ messages in thread
From: Shavonne Marietta Wijesinghe @ 2007-03-09 14:15 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Fw: CREATE TABLE
2007-03-09 14:15 Fw: CREATE TABLE Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
@ 2007-03-09 14:22 ` Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 17+ messages in thread
From: Andrew Sullivan @ 2007-03-09 14:22 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Fw: CREATE TABLE
@ 2007-03-09 14:17 Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
0 siblings, 0 replies; 17+ messages in thread
From: Shavonne Marietta Wijesinghe @ 2007-03-09 14:17 UTC (permalink / raw)
To: pgsql-sql
false alarm.. sorry
i just forgot about the """
Thanks
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.
^ permalink raw reply [nested|flat] 17+ messages in thread
end of thread, other threads:[~2007-03-09 14:37 UTC | newest]
Thread overview: 17+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-25 13:06 CREATE TABLE Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.co>
1999-02-25 18:56 CREATE TABLE Ingrith Andrea Correa Vargas <i-correa@uniandes.edu.co>
1999-02-26 07:25 ` Remigiusz Sokolowski <rems@gdansk.sprint.pl>
1999-02-26 20:51 ` David Martinez Cuevas <david@estadistica.unam.mx>
2001-04-29 19:34 create table LeoDeBeo <leodebeo@hotmail.com>
2001-05-04 16:17 ` Re: create table Martín Marqués <martin@bugs.unl.edu.ar>
2001-05-04 21:38 ` Re: create table Joel Burton <jburton@scw.org>
2001-05-04 22:43 ` Re: create table Tom Lane <tgl@sss.pgh.pa.us>
2001-05-05 16:32 ` Re: create table Albert REINER <areiner@tph.tuwien.ac.at>
2007-03-09 13:56 CREATE TABLE Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
2007-03-09 14:05 ` Milen A. Radev <milen@radev.net>
2007-03-09 14:09 ` Rodrigo De León <rdeleonp@gmail.com>
2007-03-09 14:21 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-03-09 14:37 ` Bart Degryse <Bart.Degryse@indicator.be>
2007-03-09 14:15 Fw: CREATE TABLE Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
2007-03-09 14:22 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-03-09 14:17 Fw: CREATE TABLE Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
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