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