can't read SQL dump from MySQL
От | Andreas Jerke |
---|---|
Тема | can't read SQL dump from MySQL |
Дата | |
Msg-id | NEBBKHPOGPBDEFLPBPPAEEIJCDAA.info@vrdesign.de обсуждение исходный текст |
Ответы |
Re: can't read SQL dump from MySQL
Re: can't read SQL dump from MySQL |
Список | pgsql-general |
Hi, I'm updating from MySQL to PostgrSQL. Therefor I use the mysqldump tool for exporting CREATE and INSERT statements from all tables and rows. When I try to import the SQL file into PostgreSQL with psql --> \i filename I get the following error: line 17:parser: parse error at or near "(" My SQL statement: <schnipp> 1 CREATE TABLE Adresse ( 2 pid_adresse int(11) DEFAULT '0' NOT NULL auto_increment, 3 id_person int(11) DEFAULT '0' NOT NULL, 4 PLZ varchar(50), 5 id_ort int(11) DEFAULT '0', 6 strasse varchar(50), 7 id_postcode int(11), 8 hausnummer int(11), 9 zusatz varchar(25), 10 postfach varchar(20), 11 leitcode varchar(18), 12 strassen_code char(3), 13 FZ char(3), 14 adresszusatz varchar(50), 15 PRIMARY KEY (pid_adresse), 16 KEY id_person (id_person) 17 ); <schnapp> any suggestions ? I can't find a docu for the syntax of the textfiles, which I can import with the option \i !
В списке pgsql-general по дате отправления: