Thread: default in ALTER

default in ALTER

From
Àíäðåé Íîâèêîâ
Date:
Hello.

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

Andrey Novikov




Re: [SQL] default in ALTER

From
George Moga
Date:
"Àíäðåé Íîâèêîâ" 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