>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