Re: [SQL] default in ALTER

From: George Moga <george(at)flex(dot)ro>
To: SQL PostgreSQL <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] default in ALTER
Date: 1999-04-22 11:33:39
Message-ID: 371F0913.D8041654@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)flex(dot)ro
Braila, ROMANIA

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message José Soares 1999-04-22 12:24:48 Re: [SQL] convert text to number or number to text
Previous Message novikov 1999-04-22 10:19:03 default in ALTER