>In reviewing my tables, I found that for some strange reason a handful >of fields are not double-quoted. Strange quirk: >-- Table: "Orders" > >-- DROP TABLE "Orders"; > >CREATE TABLE "Orders" >( > "OrderID" int4 NOT NULL, > "CustomerID" int4 NOT NULL, > "DateCreated" timestamptz, > "TotalPrice" numeric(19,4), > "ShipAddressID" int4, > "ShipDate" timestamptz, > "ShippingMethod" varchar(50), > "sfrepID" varchar(50), > "StatusID" int4, > "TrackingNumber" varchar(50), > ponumber varchar(50), <--------------HERE > "Comment" char(254), > "sfOrderNumber" varchar(50), > "UpdateDate" timestamptz >) >WITH OIDS; >ALTER TABLE "Orders" OWNER TO postgres; In my case, DTS's "create" always wrapped the field names with double quote. The script seems to me not from DTS. Regards, Ben Kim Developer College of Education Texas A&M University
