Re: [SQL] default in ALTER - Mailing list pgsql-sql

From George Moga
Subject Re: [SQL] default in ALTER
Date
Msg-id 371F0913.D8041654@flex.ro
Whole thread Raw
In response to default in ALTER  (Àíäðåé Íîâèêîâ <novikov@webclub.ru>)
List pgsql-sql
"Àíäðåé Íîâèêîâ" 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




pgsql-sql by date:

Previous
From: Àíäðåé Íîâèêîâ
Date:
Subject: default in ALTER
Next
From: José Soares
Date:
Subject: Re: [SQL] convert text to number or number to text