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

From björn lundin
Subject Re: newbie table design question
Date
Msg-id e1d91d71-f47e-4324-a27a-2db050951057@f16g2000vbf.googlegroups.com
Whole thread Raw
In response to newbie table design question  (Andrew Smith <laconical@gmail.com>)
Responses Re: newbie table design question
Re: newbie table design question
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: INSERT RETURNING rule for joined view
Next
From: Scott Marlowe
Date:
Subject: Re: newbie table design question