Re: newbie table design question

From: Andrew Smith <laconical(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-02 01:26:45
Message-ID: 300497a30906011826y46c0af21v62489fef194367ff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/6/2 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
>

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Bailey 2009-06-02 01:55:04 Re: ruby connect
Previous Message Tom Lane 2009-06-02 00:30:48 Re: pg_stats.avg_width differs by a factor of 4 on different machines