Re: Typed tables

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Typed tables
Date: 2010-01-10 22:34:25
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On tor, 2009-11-05 at 19:24 +0200, Peter Eisentraut wrote:
> I'm planning to work on typed tables support. The idea is that you
> create a table out of a composite type (as opposed to the other way
> around, which is currently done automatically).
> CREATE TYPE persons_type AS (name text, bdate date);
> CREATE TABLE persons OF persons_type;
> Or the fancy version:
> CREATE TABLE persons OF persons_type ( PRIMARY KEY (name) );

And here is the first patch for that. The feature is complete as far as
I had wanted it. I would like to add ALTER TYPE support, but that can
come as a separate patch.

Attachment Content-Type Size
typed-tables.patch text/x-patch 44.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2010-01-10 23:14:18 Re: Streaming replication status
Previous Message Simon Riggs 2010-01-10 22:30:53 Re: Streaming replication status