[unixODBC-support] OSX 10.7 and Postgres

Nick Gorham nick at lurcher.org
Tue Aug 28 21:50:15 BST 2012


On 28/08/2012 20:22, Gallagher James wrote:


So it looks like the SQL is hosed.


isql reads each line as a SQL Command, change

CREATE TABLE "sqlh_table"(
   "int" integer NOT NULL DEFAULT 0,
   "real" real NOT NULL DEFAULT 0,
   "varchar" character varying(50),
   CONSTRAINT pk PRIMARY KEY ("int")
);

into

CREATE TABLE "sqlh_table"( "int" integer NOT NULL DEFAULT 0, "real" real NOT NULL DEFAULT 0, "varchar" character varying(50), CONSTRAINT pk PRIMARY KEY ("int"));

And so on.

-- 
Nick




More information about the unixODBC-support mailing list