Обсуждение: I need to add a column to a table

Поиск
Список
Период
Сортировка

I need to add a column to a table

От
"Krause, Lewis"
Дата:

I know there is a command to add the column. I want to back up the table before I alter it. What is the best way. It has a couple indexes and a trigger.

If I am in the wrong forum please direct me to the right one.

Thanks.

Lewie

Re: I need to add a column to a table

От
Richard Huxton
Дата:
Krause, Lewis wrote:
> I know there is a command to add the column. I want to back up the table
> before I alter it. What is the best way. It has a couple indexes and a
> trigger.

pg_dump -t <table-name> ...


--
   Richard Huxton
   Archonet Ltd