create table/type - Mailing list pgsql-general

From Hicham G. Elmongui
Subject create table/type
Date
Msg-id cl684g$165r$1@news.hub.org
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: "Gary Doades"
Date:
Subject: Re: how much ram do i give postgres?
Next
From: Eric E
Date:
Subject: Re: Sequence question