Re: can't read SQL dump from MySQL

On Mon, 11 Sep 2000, Andreas Jerke wrote:

> 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  );

It's probably complaining about the
KEY id_person (id_person)
line since I don't think that's a
standard syntax or at least it doesn't
look like syntax postgres understands.
What's the intent behind the line?