What's the benefit (or usage scenario) of a "typed table"?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: What's the benefit (or usage scenario) of a "typed table"?
Date: 2016-12-31 15:34:56
Message-ID: o48j70$ore$1@blaine.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I recently stumbled over "typed tables" in Postgres
(there were several questions containing this on stackoverflow recently)

create type some_type as (id integer, data text);
create table some_table of some_type;

I wonder what the benefit of a typed table is and when this would be useful?

Regards
Thomas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-12-31 15:51:01 Re: What's the benefit (or usage scenario) of a "typed table"?
Previous Message Tim Uckun 2016-12-31 10:49:33 Re: Performance PLV8 vs PLPGSQL