Hey guys I built the string in python and then passed it to the cur.execute() function. This was so simple! It scares me to see that I didn't get it the first time around. But anyway, thanks for laying to rest my confusions. Thank you so much!
On Fri, Mar 11, 2016 at 01:16:33AM +0530, Shaan Repswal wrote:
> I am new to databases and am a novice to programming in general.
Don't worry. > @Karsten - I know, I got the feeling that the design felt awry as well. The > database will be on the local machine. And the client side will have the > code to error check the column names being added and also if there already > is a column by this name or not.
You can add a second table (pseudo code)
inventory_detail pk serial primary key fk_inventory integer foreign key (inventory.pk) detail_name text detail_value text
and then - instead of creating columns in table inventory - add rows to the inventory_detail table where .detail_name would hold what otherwise would be the column name of the new column in inventory and .detail_value the value you would have put into the new column in table inventory. The fk_inventory column would hold the primary key of the row in the inventory table this inventory_detail row belongs to.