By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,117 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,117 IT Pros & Developers. It's quick & easy.

Dynamic Fields

P: 23
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...
May 5 '09 #1
Share this Question
Share on Google+
8 Replies


Expert 100+
P: 700
What is the diffrenece between columns and dynamic fields?
May 6 '09 #2

P: 23
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.
May 6 '09 #3

Expert 100+
P: 700
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?
May 6 '09 #4

P: 23
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. :)
May 6 '09 #5

Expert 100+
P: 700
Should the dynamic fields be stored in the database, or dynamicaly computed?
May 6 '09 #6

P: 23
@rski

Any solution is OK. As long as it is work for this.
May 7 '09 #7

P: 23
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. :)
May 7 '09 #8

Expert 100+
P: 700
Show your proposition cos I'm still a bit confused?
May 7 '09 #9

Post your reply

Sign in to post your reply or Sign up for a free account.