Received: from flex.flex.ro (IDENT:root@[193.230.255.4]) by hub.org (8.9.3/8.9.1) with ESMTP id HAA46643 for ; Thu, 22 Apr 1999 07:34:59 -0400 (EDT) (envelope-from george@flex.ro) Received: from flex.ro (george.flex.ro [193.230.255.93]) by flex.flex.ro (8.9.1/8.9.1) with ESMTP id NAA21435 for ; Thu, 22 Apr 1999 13:34:47 +0300 Sender: gestoc@flex.flex.ro Message-ID: <371F0913.D8041654@flex.ro> Date: Thu, 22 Apr 1999 14:33:39 +0300 From: George Moga X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.2.2 i586) X-Accept-Language: ro MIME-Version: 1.0 To: SQL PostgreSQL Subject: Re: [SQL] default in ALTER References: <6596.990422@webclub.ru> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit "Андрей Новиков" 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