Re: newbie table design question

From: björn lundin <b(dot)f(dot)lundin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: newbie table design question
Date: 2009-06-01 19:03:46
Message-ID: e1d91d71-f47e-4324-a27a-2db050951057@f16g2000vbf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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
--
Björn Lundin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-06-01 20:08:53 Re: newbie table design question
Previous Message Tom Lane 2009-06-01 18:35:52 Re: INSERT RETURNING rule for joined view