Postgres Pro
Downloads
Home   >   mailing lists

Re: constaint addition to existing schema - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: constaint addition to existing schema
Date
Msg-id 20031224040638.GB626@wolff.to
Whole thread Raw
In response to constaint addition to existing schema  (Jodi Kanter <jkanter@virginia.edu>)
List pgsql-admin
Tree view 
On Mon, Dec 22, 2003 at 12:26:18 -0500,
  Jodi Kanter <jkanter@virginia.edu> wrote:
> I missed a constraint the last time that I loaded my database. Can I add
> an additional constraint without having to drop and rerun the table?
> If not, can I do just that one table without having to do the entire schema?
> Jodi

ALTER TABLE should allow you to do this.

pgsql-admin by date:

Previous
From: Yuji Shinozaki
Date:
Subject: Re: constaint addition to existing schema
Next
From: "Iain"
Date:
Subject: Re: ERROR: canceling query due to user request