hello gurus
| От | Ganesh Rajan |
|---|---|
| Тема | hello gurus |
| Дата | |
| Msg-id | 003c01c2a505$614fe280$4501a8c0@zeomega.org обсуждение исходный текст |
| Ответы |
Re: hello gurus
|
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: