Home > mailing lists

Create a view with variable amount of columns depending on the rows of a table - Mailing list pgsql-general

From	Stefan Gündhör
Subject	Create a view with variable amount of columns depending on the rows of a table
Date	March 14, 2011 19:29:16
Msg-id	AANLkTi=2EddLbjLEq_e6__a9i4NraxyVjMsuhuWHd8hw@mail.gmail.com Whole thread Raw
Responses	Re: Create a view with variable amount of columns depending on the rows of a table (Merlin Moncure <mmoncure@gmail.com>)
List	pgsql-general

Hi,

If I have following tables for example:

# Main Table:

id(id/pk) | geometry

---------------------------

1 | ...

# Additional Attribute Table:

name(id/pk) | value

---------------------------

date_added | 20.12.1988

name | Vienna

# m:n table:

mainTableID | attrTableID

-----------------------------------

1 | date_added

1 | name

And i would like to automatically generate a View like

the following:

id(id/pk) | geometry | date_added | name

-----------------------------------------------------------

1 | ... | 20.12.1988 | Vienna

This example is a simplified (and not really functional) version of what I would like to do -

but it should make clear what I have in view: Dynamically generating a View's columns depending on the rows of a table.

Does anybody know, if this is possible?

Thank you for your replies in advance,

best regards,

Stefan Gündhör

From: gene.poole@macys.com
Date: 14 March 2011, 19:22:03
Subject: Move From Oracle DB to PostgreSQL DB

From: Devrim GÜNDÜZ
Date: 14 March 2011, 19:34:16
Subject: Re: Move From Oracle DB to PostgreSQL DB