Обсуждение: default in ALTER

Поиск
Список
Период
Сортировка

default in ALTER

От
Àíäðåé Íîâèêîâ
Дата:
Hello.

Is there any way to set default value in
alter table products add column ...

Andrey Novikov




Re: [SQL] default in ALTER

От
George Moga
Дата:
"Àíäðåé Íîâèêîâ" wrote:

> Hello.
>
> Is there any way to set default value in
> alter table products add column ...
>
> Andrey Novikov

If I know the right answer, is no way to add default value for a field whith
alte table command.

When I want to add a default value I do:

1. pg_dump database > one_file.sql
2. edit the .sql file
3. recreate the database from file.sql

Sorry for my english.

--
Best,       George Moga,       george@flex.ro       Braila, ROMANIA