can't read SQL dump from MySQL

From: "Andreas Jerke" <info(at)vrdesign(dot)de>
To: "Pgsql-General" <pgsql-general(at)hub(dot)org>
Subject: can't read SQL dump from MySQL
Date: 2000-09-11 10:38:54
Message-ID: NEBBKHPOGPBDEFLPBPPAEEIJCDAA.info@vrdesign.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Welche 2000-09-11 10:56:32 Re: PostgreSQL + PHP can't connect
Previous Message Martin A. Marques 2000-09-11 10:05:28 problems with GRANT on Solaris 8