From: | "Command Prompt, Inc(dot)" <pgsql-general(at)commandprompt(dot)com> |
---|---|
To: | Samik Raychauhduri <samik(at)cae(dot)wisc(dot)edu> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SQL: Are the "" around table & coloumnames necessary? |
Date: | 2002-02-19 06:23:06 |
Message-ID: | Pine.LNX.4.30.0202182222550.30863-100000@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If the column names are capitalized they are required.
On Mon, 18 Feb 2002, Samik Raychauhduri wrote:
> Are you using psql or any other program interface to write queries? For
> me the queries does work without quotes around column-names.
> HTH. Regards.
> -Samik
>
> Mikey wrote:
>
> > Hello,
> >
> > when I write a select for example,
> > it doesn't work this way:
> >
> > select col1, col2
> > from my_table;
> >
> > instead of that I have to write
> >
> > select "col1", "col2"
> > from "my_table";
> >
> > I dont understand this...is there a way to use
> > the more comfortable form without "" ?
> >
> > thx
> >
> > ...Mike
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
--
by way of pgsql-general(at)commandprompt(dot)com
http://www.postgresql.info/
http://www.commandprompt.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Command Prompt, Inc. | 2002-02-19 06:24:08 | Re: PgManage update |
Previous Message | Rich Shepard | 2002-02-19 05:20:42 | Re: Alternate database locations |