Re: I need to add a column to a table

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Krause, Lewis" <Lewis(dot)Krause(at)echostar(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: I need to add a column to a table
Date: 2004-11-24 09:03:48
Message-ID: 41A44E74.2020806@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-11-24 09:26:31 Re: VACUUM and ANALYZE With Empty Tables
Previous Message Chris Green 2004-11-24 08:56:54 Re: Any good report/form generators for postgresql?