Re: Default value after table create

From: "Florian Helmberger" <f(dot)helmberger(at)uptime(dot)at>
To: "Robson" <robson-martins(at)bol(dot)com(dot)br>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Default value after table create
Date: 2002-06-21 12:37:14
Message-ID: OPEOLKEAAIMGBAMJNACKMEFNEJAA.f.helmberger@uptime.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi.

alter table <table_name> alter column <column_name> add default <default>;

Cheers,
Florian
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Robson
Sent: Friday, June 21, 2002 2:13 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Default value after table create
Importance: High

With set default value, after table create ?

with pgAdmin II , psql, or etc...

Regards,

Robson

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-06-21 14:25:34 Re: lost superuser perms
Previous Message Robson 2002-06-21 12:13:28 Default value after table create