Re: [GENERAL] I need to add a column to a table

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 ---(end of

[GENERAL] I need to add a column to a table

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