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 !