Re: adding defaults

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