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

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/