Received: from news.tht.net (news.hub.org [216.126.91.242] (may be forged)) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1ID0mE37875 for ; Mon, 18 Feb 2002 08:00:49 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id g1ICh1c30987 for pgsql-sql@postgresql.org; Mon, 18 Feb 2002 07:43:01 -0500 (EST) (envelope-from news) From: mikey.unsafe@gmx.net (Mikey) X-Newsgroups: comp.databases.postgresql.sql Subject: SQL: Are the "" around table & coloumnames necessary? Date: 18 Feb 2002 04:43:00 -0800 Organization: http://groups.google.com/ Lines: 19 Message-ID: <26282372.0202180442.75f0c4c9@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200202/279 X-Sequence-Number: 6702 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