Thread: Oracle8 / PostgreSQL

Oracle8 / PostgreSQL

From
Ines.Klimann@liafa.jussieu.fr
Date:
Hello,


does someone know how I can do this in PostgreSQL ?
(this is in Oracle8) :

CREATE OR REPLACE TYPE adresse_type AS OBJECT
(norue NUMBER,
rue VARCHAR2(20),
ville VARCHAR2(30),
code_postal VARCHAR2(5));
/

CREATE TABLE adresse OF adresse_type
/

Thanks,
Ines.