Message-ID: <20050309104616.8cjneru7plccgss4@www.presserv.org>
Date: Wed,  9 Mar 2005 10:46:16 -0300
From: lucas@presserv.org
To: pgsql-sql@postgresql.org
Subject: Table like a field
MIME-Version: 1.0
Content-Type: text/plain;
	charset=ISO-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
User-Agent: Internet Messaging Program (IMP) H3 (4.0)

Hello.
Is there any way to build a table that contain the coluns name for the other
table fields? like this:

 create table people(id serial primary key, name varchar(50) );
 create table people_fields ( field_name varchar(30) );
 insert into people_fields values ('occupation');
 insert into people_fields values ('address');

 then I create any function or view to get:
 SELECT * FROM people; //may return

 id - name - | ocuppation - address |

 Then if I insert a new record in the people_fields table, the new record will
appear as a new field in the people table.
 Of course, its not a new field, but when i select by my function/view i can see
anything like it.

 How can I create this function to aggregate the both tables??

Thank you.