Skip site navigation (1) Skip section navigation (2)

constaint addition to existing schema

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: constaint addition to existing schema
Date: 2003-12-22 17:26:18
Message-ID: 3FE7293A.8010203@virginia.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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
-- 

/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>/

 

/ /

/ /

Responses

pgsql-admin by date

Next:From: scott.marloweDate: 2003-12-22 17:31:15
Subject: Re: pg_dump vs pg_dumpall - small database cluster,
Previous:From: Sai Hertz And Control SystemsDate: 2003-12-22 15:58:23
Subject: Unix 2038 And PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group