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

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

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-sql by date

  From Date Subject
Next Message suresh 2002-02-18 13:30:49 Need to change the size of a field
Previous Message Rod Taylor 2002-02-18 12:40:16 Re: Function to split pg_trigger.tgargs