Dynamic Fields

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...

re: Dynamic Fields

What is the diffrenece between columns and dynamic fields?

re: Dynamic Fields

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.

re: Dynamic Fields

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

What dose it mean
Can you give an example what do you want to achieve?

re: Dynamic Fields

Thanks for the reply.

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. :)

re: Dynamic Fields

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

re: Dynamic Fields

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

re: Dynamic Fields

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. :)

re: Dynamic Fields

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