Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

        George Moga,
        Braila, ROMANIA

In response to

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group