Postgres Pro
Downloads
Home   >   mailing lists

Re: I need to add a column to a table - Mailing list pgsql-general

From Richard Huxton
Subject Re: I need to add a column to a table
Date
Msg-id 41A44E74.2020806@archonet.com
Whole thread Raw
In response to I need to add a column to a table  ("Krause, Lewis" <Lewis.Krause@echostar.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Net Virtual Mailing Lists"
Date:
Subject: Creating index on a view?
Next
From: Richard Huxton
Date:
Subject: Re: VACUUM and ANALYZE With Empty Tables