Re: Is this doable using Postgresql crosstab or some other function?

From: <mika(at)digikartta(dot)net>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is this doable using Postgresql crosstab or some other function?
Date: 2012-04-10 09:27:20
Message-ID: f3bd97529dd77f1f0d3235b8fc4e41cc@digikartta.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Let's say I have tens or hundreds or thousands of feature (instance)
types. Each of them would need its own table.
Let's say I give for the application administrator, a possibility to
create new feature types? He/she merely knows what's the database is.
So I need a model which is capable for offering "dynamic table
structures".

I already have implemented parts which allow creating these types,
creating instances of them and populating those instances with data. Now
I have to come up with a method for flattening that data into one view
so that it can be used directly.

- mika -

On Tue, 10 Apr 2012 01:58:46 -0700, John R Pierce <pierce(at)hogranch(dot)com>
wrote:
> On 04/10/12 1:52 AM, mika(at)digikartta(dot)net wrote:
>>
>> Quite challanging, right?
>
> yes.
>
> and quite contrary to the relational data model.
>
> whats the point of going to all this abstraction?
>
> --
> john r pierce N 37, W 122
> santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mika 2012-04-10 09:29:14 Re: Is this doable using Postgresql crosstab or some other function?
Previous Message David Johnston 2012-04-10 09:19:14 Re: Is this doable using Postgresql crosstab or some other function?