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

From: mikey(dot)unsafe(at)gmx(dot)net (Mikey)
To: pgsql-general(at)postgresql(dot)org
Subject: SQL: Are the "" around table & coloumnames necessary?
Date: 2002-02-18 12:46:11
Message-ID: 26282372.0202180446.7634d42e@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-02-18 13:06:00 Re: Database Performance?
Previous Message Nicolas Kuhl 2002-02-18 12:29:24 Using Connecting to Postgresql from MS Access