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 !
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 |