Using double quotes in create table statement!

From: "Israel Calderon" <icalderus(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Using double quotes in create table statement!
Date: 2003-05-06 16:38:59
Message-ID: Sea2-F231HSiHkDlPKh0000699e@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hello I am currently analyzing a db schema and ran across something which I
am not familiar with. The table name within the create statement is enclosed
within double quotes as well as a column within the table. Heres the format:

CREATE TABLE "xyz"(
act_act character varying (40),
"action" character varying (30),
st_id uniqueidentifier DEFAULT newid() NOT NULL
);

The "xyz" and "action" portions of this create statement I do not
understand. Can anyone elaborate on this? Much appreciated!

_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Juliet May 2003-05-06 16:49:30 accessing bitmap stored in an ole object
Previous Message Josh Berkus 2003-05-06 15:57:06 Re: OFF-TOPIC: Application Development with PostgreSQL