Re: newbie table design question

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: björn lundin <b(dot)f(dot)lundin(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: newbie table design question
Date: 2009-06-01 20:08:53
Message-ID: dcc563d10906011308v5a7cf3a8se277c4d6b01af732@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/6/1 björn lundin <b(dot)f(dot)lundin(at)gmail(dot)com>:
>
>> CREATE TABLE "DataImport"
>> (
>>   "DataImportID" serial NOT NULL PRIMARY KEY,
>>   "Time" timestamp without time zone NOT NULL,
>>   "ID_ABC" integer NOT NULL,
>>   "ID_DEF" integer NOT NULL,
>>   "ID_HIJ" integer NOT NULL,
>>   etc
>> );
>
> Perhaps you want to not use the "" around the table and column names.
> It makes them case sensitive

OR always always always use them. But yeah, I find having to quote my
identifiers all the time a gigantic pain.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-06-01 20:20:18 Re: INSERT RETURNING rule for joined view
Previous Message björn lundin 2009-06-01 19:03:46 Re: newbie table design question