How to change the structure of tables with pgadmin2?

Поиск
Список
Период
Сортировка
От NH-Jason
Тема How to change the structure of tables with pgadmin2?
Дата
Msg-id 000a01c1aa2b$8bea7a80$2101a8c0@nht.com
обсуждение исходный текст
Список pgadmin-support
Hi,
    I'm an in-house VB programmer working with VB + Pg. pgAdmin2 is very valuable to me.
 
    I have to change the tables' structures (add / delete column name, indexes; change data type ...) from time to time. I understand changing some of the schema thing is impossible with pg, so I will copy the SQL defination of the schema offered by pgAdmin2, drop the table, change the SQL defination and rebuild it. Everything's fine except all the data (mostly testing data) gone. Is there existing pgadmin / plug-in feature is able to do the job for me?
 
-Jason

В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Default Values
Следующее
От: Dave Page
Дата:
Сообщение: Re: How to change the structure of tables with