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

From mikey.unsafe@gmx.net (Mikey)
Subject SQL: Are the "" around table & coloumnames necessary?
Date
Msg-id 26282372.0202180446.7634d42e@posting.google.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Eric Veldhuyzen
Date:
Subject: execute permissions of stored procedures?
Next
From: Dave Smith
Date:
Subject: Can somebody save my bacon?