Re: when I create a table, postgresql creates a new type

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Julio Misael Gutierrez <jmisaelg(at)amnetsal(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: when I create a table, postgresql creates a new type
Date: 2004-01-19 18:26:08
Message-ID: Pine.LNX.4.33.0401191125170.11187-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 15 Jan 2004, Julio Misael Gutierrez wrote:

> Good day,
> I´m testing PostGresql,
> I would like to Know why when I create a new table,
> postgresql create a new type with the same name of the table.
> Where I can find more information about this?.

To add to what Tom said, this allows you to create functions that return a
set of 'newtable_type' where newtable_type is the newtable you've
created. I.e. you can have a function return rows just like the table you
created. nifty, huh?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2004-01-19 18:28:19 Re: Postgress and MYSQL
Previous Message Andrew Sullivan 2004-01-19 18:23:48 Re: Postgress and MYSQL