Re: Ad-hoc table type? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Ad-hoc table type?
Date
Msg-id 21349.1222641574@sss.pgh.pa.us
Whole thread Raw
In response to Ad-hoc table type?  (pgsql@mohawksoft.com)
Responses Re: Ad-hoc table type?  (pgsql@mohawksoft.com)
List pgsql-hackers
pgsql@mohawksoft.com writes:
> Something like this:

> create adhoc table foo ();

> insert into foo (name, rank, serial) values ('joe', 'sargent', '42');

> In an "ad-hoc" table type, when an insert is made, and a column is not
> found, then a new varchar column is added.

> I know the idea has a lot of holes, and is probably a bad idea, but it
> answers an important problem of easily mapping programmatic types to a
> database.

Seems like a table with one contrib/hstore column might be more relevant
to this guy's idea of how to do database design.
        regards, tom lane


pgsql-hackers by date:

Previous
From: pgsql@mohawksoft.com
Date:
Subject: Ad-hoc table type?
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: Ad-hoc table type?