Обсуждение: hello gurus
hello gurus,
iam facing a problem....
1) my database needed somechanges like increase in width for a varchar datatype column... since there is no option like using "ALTER TABLE ...." i have to drop the table & recreated.... so i did.... since the oid of this table is changed.... the tables & views referencing this table started to throw error...
what i did is that...i took the dump "pg_dump db_name > db_name.sql" .... and edited the script file & dont with the changes...
is there any other way to change the structure...other than the way i done with..
2) i added another column to the table... now when i want to insert the value for this column the the dump script file... how to add the value for this column ...note: this column is my column in that table...
Please help required.....
Ganesh Rajan
On Monday 16 December 2002 06:46 pm, Ganesh Rajan wrote: > hello gurus, > > iam facing a problem.... > 1) my database needed somechanges like increase in width for a varchar > datatype column... since there is no option like using "ALTER TABLE ...." i > have to drop the table & recreated.... so i did.... since the oid of this > table is changed.... the tables & views referencing this table started to > throw error... you could have added a new column of reqd type, updated the new col with values from old col, dropped the old col and renamed the new col to old col. there was no need to drop entire table. > > what i did is that...i took the dump "pg_dump db_name > db_name.sql" .... > and edited the script file & dont with the changes... is there any other > way to change the structure...other than the way i done with.. > > > 2) i added another column to the table... now when i want to insert the > value for this column the the dump script file... how to add the value for > this column ...note: this column is my column in that table... the prev suggestion will help. > > > Please help required..... > > > Ganesh Rajan -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.