Re: newbie table design question - Mailing list pgsql-general

From Andrew Smith
Subject Re: newbie table design question
Date
Msg-id 300497a30906011826y46c0af21v62489fef194367ff@mail.gmail.com
Whole thread Raw
In response to Re: newbie table design question  (björn lundin <b.f.lundin@gmail.com>)
Responses Re: newbie table design question
List pgsql-general


2009/6/2 björn lundin <b.f.lundin@gmail.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

Yes, that's exactly why I've got them there. I can't stand lowercase field names in tables.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_stats.avg_width differs by a factor of 4 on different machines
Next
From: Scott Bailey
Date:
Subject: Re: ruby connect