> 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.