Re: adding defaults
От
Rosser Schwarz
Тема
Re: adding defaults
Дата
Msg-id
37d451f704071410117a8cc088@mail.gmail.com
Ответ на
adding defaults (Jodi Kanter)
Список
Дерево обсуждения
adding defaults Jodi Kanter <jkanter@virginia.edu>
Re: adding defaults Oliver Elphick <olly@lfix.co.uk>
Re: adding defaults Peter Eisentraut <peter_e@gmx.net>
Re: adding defaults Rosser Schwarz <rosser.schwarz@gmail.com>
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
В списке pgsql-admin по дате отправления
