Thread: Re: SQL: Are the "" around table & coloumnames necessary?

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
>

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/

I have to use quotes at psql, pgadmin II and
other interfaces...
The postgresql 7.2 backend is on SuSE 7.0
I also have a 7.1.3 installation on a RedHat 7.1
and there I HAVENT to use quotes!
...I dont know why...

Samik Raychauhduri <samik@cae.wisc.edu> wrote in message news:<3C71B2C4.3050305@cae.wisc.edu>...
> 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