Changing column modifiers?

Поиск
Список
Период
Сортировка
От Tim Boring
Тема Changing column modifiers?
Дата
Msg-id 1000084115.4120.2.camel@tim
обсуждение исходный текст
Список pgsql-admin
Can you change a column modifier after you've created the table?  For
example, I have a table called "authors" with the following columns:
authorid, authorfirstname, authorlastname, authormi, statecode, country,
born, deceased.

When I created the table, I forgot to make the "authorfirstname" and
"authorlastname" columns NOT NULL.  I've looked at ALTER TABLE but I
don't see a way to use it to add NOT NULL...maybe I'm just missing the
obvious?

Any help/suggestions are appreciated.

Thanks,
Tim




В списке pgsql-admin по дате отправления:

Предыдущее
От: pmiranda@vm.com.br
Дата:
Сообщение: Re: pg_dump & windows (what a mess...!)
Следующее
От: Mohammad Faisal
Дата:
Сообщение: primary key problem