Re: SQL: Are the "" around table & coloumnames necessary? - Mailing list pgsql-general

From Command Prompt, Inc.
Subject Re: SQL: Are the "" around table & coloumnames necessary?
Date
Msg-id Pine.LNX.4.30.0202182222550.30863-100000@commandprompt.com
Whole thread Raw
In response to Re: SQL: Are the "" around table & coloumnames necessary?  (Samik Raychauhduri <samik@cae.wisc.edu>)
List 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@commandprompt.com
http://www.postgresql.info/
http://www.commandprompt.com/


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Alternate database locations
Next
From: Jean-Michel POURE
Date:
Subject: Re: Extending PostgreSQL