Re: how to create a new composite type using already existing composite types - Mailing list pgsql-general

From Jeff Davis
Subject Re: how to create a new composite type using already existing composite types
Date
Msg-id 1266107070.29919.5924.camel@jdavis
Whole thread Raw
In response to how to create a new composite type using already existing composite types  (Iain Barnett <iainspeed@gmail.com>)
Responses Re: how to create a new composite type using already existing composite types
List pgsql-general
On Wed, 2010-02-10 at 03:46 +0000, Iain Barnett wrote:

> CREATE TYPE inventory_item2 AS (
>     name            text,
>     supplier_id     integer,
>     price           numeric,
> size    integer
> );
>
>
> but it would be handy if I could reuse inventory_item instead of
> having to retype the whole lot. I can't work out or find the right
> syntax, can anyone show me how? Any help would be much appreciated.

What about:

  CREATE TYPE inventory_item2 AS (
    ii inventory_item,
    size integer
  );

or:

  CREATE TABLE inventory_item2 (
    LIKE inventory_item,
    size integer
  );

and that will automatically create the type.

Regards,
    Jeff Davis



pgsql-general by date:

Previous
From: Diego Schulz
Date:
Subject: Re: Problemas con la copia de seguridad PostgresSQL
Next
From: Janet S Jacobsen
Date:
Subject: unable to restore from a pgdump file