[SQL] Oracle8 / PostgreSQL

[Ines . Klimann]

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.