Jodi Kanter wrote:
> Can field specific defaults easily be added to a table that is
> already in existence and has data in it?  I cannot seem to locate the
> correct ALTER command in any of my books.

ALTER TABLE a ALTER COLUMN b SET DEFAULT c;

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to