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

From Samik Raychauhduri
Subject Re: SQL: Are the "" around table & coloumnames necessary?
Date
Msg-id 3C71B2C4.3050305@cae.wisc.edu
Whole thread Raw
Responses Re: SQL: Are the "" around table & coloumnames necessary?  ("Command Prompt, Inc." <pgsql-general@commandprompt.com>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: "Dr. Evil"
Date:
Subject: Default timezones and Postgres
Next
From: Samik Raychaudhuri
Date:
Subject: Selectively compile psql