Dynamic Fields

[lion cave]

Hi hello,

I have a task assignment regarding for the dynamic fields. My task is to create a table in postgresql database and make the fields of this table a dynamic.

This means that the table can be added, renamed and deleted the fields. On ther hand, the datatype of field can be changed also.

One that come up to my mind to solve this through procedural language for the PostgreSQL. But I'm a newbee for this. Well, I'm studying this procedural as fast as i can.

Do you have any idea on how to make a dynamic fields to the table?
I also want a help regarding to procedural on how to make this dynamic fields if this is the way to solution.

I appreciate for any idea. Thanks...

[rski]

What is the diffrenece between columns and dynamic fields?

[lion cave]

Thanks for the reply.
The columns and fields that i'm referring is the same.

This kind of problem is that i can add, delete or update a column name together with its datatype without altering the table.

Hope you reply.

[rski]

gosh my english isn't good enough because I completly don't know what you are talking about :).

What dose it mean

can add, delete or update a column name together with its datatype without altering the table.

Can you give an example what do you want to achieve?

[lion cave]

Thanks for the reply.

can add, delete or update a column name together with its datatype without altering the table.

when i want to add a new field to an existing table(which has already fields itself) then, i want to add a field to this table without altering it.

For example, table name: person has a field which is a name, then, i want to add a field which is an age. Then, i query the person table then it would output of these fields: name and age.
Same also with updating or renaming or deleting the field.
But this should not use in adding through alter.

Well, the buttom point for this is to make a dynamic fields for a table.

Any form of idea is welcome.
Ay suggestion is welcome.
hope you reply again.

thanks.
Sorry for my english. :)

[rski]

Should the dynamic fields be stored in the database, or dynamicaly computed?

[lion cave]

Should the dynamic fields be stored in the database, or dynamicaly computed?

Any solution is OK. As long as it is work for this.

[lion cave]

hi hello, thaks a lot for your help.

I have an idea on how to solve this problem.

But, if you have an idea for this, I am still willing to hear from you.

Thanks a lot. :)

[rski]

Show your proposition cos I'm still a bit confused?