Re: constaint addition to existing schema

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: constaint addition to existing schema
Date: 2003-12-24 04:06:38
Message-ID: 20031224040638.GB626@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Dec 22, 2003 at 12:26:18 -0500,
Jodi Kanter <jkanter(at)virginia(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2003-12-25 00:28:58 Re: [GENERAL][HACKERS]data fragmentation
Previous Message Iain 2003-12-24 03:16:42 Re: FATAL: unrecognized configuration parameter "show_statement_stats"