Oracle8 / PostgreSQL

From: Ines(dot)Klimann(at)liafa(dot)jussieu(dot)fr
To: pgsql-sql(at)postgresql(dot)org
Subject: Oracle8 / PostgreSQL
Date: 2001-02-14 12:13:01
Message-ID: 20010214131301.A23107@liafa0.liafa.jussieu.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-sql by date

  From Date Subject
Next Message Jaros³aw B³¹d 2001-02-14 12:22:23 Re: binary operators
Previous Message Richard Huxton 2001-02-14 11:32:04 Re: constraint/restrict