Received: from shiva.jussieu.fr (shiva.jussieu.fr [134.157.0.129]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1ECD7x22266 for ; Wed, 14 Feb 2001 07:13:09 -0500 (EST) (envelope-from klimann@liafa.jussieu.fr) Received: from mail.liafa.jussieu.fr (liafa1.liafa.jussieu.fr [132.227.81.128]) by shiva.jussieu.fr (8.10.0/jtpda-5.3.3) with ESMTP id f1ECD1q69363 for ; Wed, 14 Feb 2001 13:13:01 +0100 (CET) Received: from liafa0.liafa.jussieu.fr (liafa0.liafa.jussieu.fr [132.227.81.1]) by mail.liafa.jussieu.fr (8.9.3/jtpda-5.3.2) with ESMTP id NAA26959 for ; Wed, 14 Feb 2001 13:13:01 +0100 (MET) From: Ines.Klimann@liafa.jussieu.fr Received: from (klimann@localhost) by liafa0.liafa.jussieu.fr (8.9.3/jtpda-5.3.2) id NAA23244 for pgsql-sql@postgresql.org; Wed, 14 Feb 2001 13:13:01 +0100 Date: Wed, 14 Feb 2001 13:13:01 +0100 To: pgsql-sql@postgresql.org Subject: Oracle8 / PostgreSQL Message-ID: <20010214131301.A23107@liafa0.liafa.jussieu.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3us X-Archive-Number: 200102/253 X-Sequence-Number: 1444 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.