From: lucas@presserv.org
To: pgsql-sql@postgresql.org
Subject: Table like a field
Date: Wed, 9 Mar 2005 10:46:16 -0300
Message-ID: <20050309104616.8cjneru7plccgss4@www.presserv.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lucas@presserv.org
Subject: Re: Table like a field
In-Reply-To: <20050309104616.8cjneru7plccgss4@www.presserv.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox