Re: can't read SQL dump from MySQL

On Mon, Sep 11, 2000 at 03:46:26PM +0200, Andreas Jerke wrote:
> thanks for help,
> I fixed this with:
>
> CREATE TABLE Adresse (
>   pid_adresse INT8 DEFAULT NEXTVAL('seqAdresse') PRIMARY KEY,
                INT4 would do the job here.

>   id_person int4 DEFAULT '0' NOT NULL,
>   PLZ varchar(50),
>   id_ort int4 DEFAULT '0',
>   strasse varchar(50),
>   id_postcode int4,
>   hausnummer int4,
>   zusatz varchar(25),
>   postfach varchar(20),
>   leitcode varchar(18),
>   strassen_code char(3),
>   FZ char(3),
>   adresszusatz varchar(50)
> );

Integer Types

 ___mysql____________ postgress_____________
 int1 = tinyint(4)    -            =    8Bit
 int2 = smallint(6)   int2         =   16Bit
 int3 = mediumint(9)  -            =   24Bit
 int4 = int(11)       int4         =   32Bit
 int8 = bigint(20)    int8         =   64Bit

i think that the mysql syntax like tinyint(4) stands for less than 4 digist.

Chears,
Gunnar von Boehn
--
LinuxHaus Stuttgart                    | Tel.:  +49 (7 11) 2 85 19 05
D-70734 Fellbach                       | Fax:   +49 (7 11) 5 78 06 92
Linux, Netzwerke, Consulting & Support | http://lihas.de