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/