Oracle8 / PostgreSQL - Mailing list pgsql-sql

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.