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

From mikey.unsafe@gmx.net (Mikey)
Subject SQL: Are the "" around table & coloumnames necessary?
Date
Msg-id 26282372.0202180442.75f0c4c9@posting.google.com
Whole thread Raw
Responses Re: SQL: Are the "" around table & coloumnames necessary?  (Oliver Elphick <olly@lfix.co.uk>)
List 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


pgsql-sql by date:

Previous
From: "D'laila Pereira"
Date:
Subject: all tables in a DB\?
Next
From: ishapiro@cogitations.com (Irv Shapiro)
Date:
Subject: Casting pairs of floating point variables as a point in plpgsql