On Mon, Dec 22, 2003 at 12:26:18 -0500,
Jodi Kanter <[EMAIL PROTECTED]> 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
You should probably read about the specifics in the documentation
(see http://www.postgresql.org/docs/)
But you could use something like (e.g.)
ALTER TABLE ONLY question_category
ADD CONSTRAINT question_category_external_id_key UNIQUE (external_id);
which adds a UNIQUE
