2009/6/2 björn lundin <b.f.lundin@xxxxxxxxx>
Yes, that's exactly why I've got them there. I can't stand lowercase field names in tables.
Perhaps you want to not use the "" around the table and column names.
> 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
> );
It makes them case sensitive
Yes, that's exactly why I've got them there. I can't stand lowercase field names in tables.