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

From: Samik Raychauhduri <samik(at)cae(dot)wisc(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL: Are the "" around table & coloumnames necessary?
Date: 2002-02-19 02:04:52
Message-ID: 3C71B2C4.3050305@cae.wisc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Samik Raychaudhuri 2002-02-19 02:05:04 Selectively compile psql
Previous Message Christopher Kings-Lynne 2002-02-19 01:34:16 PostgreSQL talk at UWA