create table/type

From: "Hicham G(dot) Elmongui" <elmongui(at)cs(dot)purdue(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: create table/type
Date: 2004-10-20 17:43:44
Message-ID: cl684g$165r$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

is there a way to create a table with a certain type?

CREATE TYPE typename AS (id integer, name varchar);

and something like

CREATE TABLE names OF TYPE typename.

Is there a syntax to support this?

thanks,
--h

Browse pgsql-general by date

  From Date Subject
Next Message Gary Doades 2004-10-20 17:47:25 Re: how much ram do i give postgres?
Previous Message Hagen Hoepfner 2004-10-20 17:32:07 Re: Views + UNION ALL = Slow ?