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.
$ psql -c "\h alter table" | grep -iC 1 default
ALTER TABLE [ ONLY ] name [ * ]
ALTER [ COLUMN ] column { SET DEFAULT expression | DROP DEFAULT }
...
/rls
--
:wq
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
