OK, I've another question. This one is about the INSERT command. When I uncomment some of these statements I get an error in regards to a comma. What I'm afraid of is that perhaps there is a compatibility issue such that an INSERT command on Postgres can't take as many records as MySQL. Seems to me that this is the kind of thing which could cause an error like this.
Example: [EMAIL PROTECTED] jims]$ grep "INSERT INTO \"channel\"" mysqlDump.postgres.working.sql INSERT INTO "channel" VALUES (1033,'33','33',1,'CBUT','CBC (Vancouver) (CBUT)','',NULL,'','10100',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,33,0),(1069,'69','69',1,'CNBC','CNBC','',NULL,'','10139',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,69,0),(1066,'66','66',1,'CNN','Cable News Network','',NULL,'','10142',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,66,0),(1067,'67','67',1,'CNNH','CNN Headline News','',NULL,'','10145',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,67,0),(1047,'47','47',1,'COMEDYP','Comedy Central (Pacific)','',NULL,'','10150',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,47,0),(1024,'24','24',1,'CSPAN','Cable Satellite Public Affairs ... [goes on for another page or two] While the error is: > [EMAIL PROTECTED] jims]$ psql inscom < mysqlDump.postgres.working.sql 2>&1 | > grep ERROR > ERROR: syntax error at or near "," at character 164 So anyway, it's all in the same INSERT command although there are additional INSERT's for the same table. Think I'm on the right track? Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
