alter table

From: "Yuri A(dot) Kabaenkov" <sec(at)artofit(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: alter table
Date: 2001-11-30 15:22:56
Message-ID: 1518677747.20011130182256@artofit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I've read documentation on alter table syntax and doesn't find
anything about change column type or drop column.

Also when i add column by command
alter table test add column a integer not null default '10'

It adds column but doesn't set default value.

How can i fix it?

------------
With respect,
Yuri A. Kabaenkov
hellman(at)artofit(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-30 15:33:42 Re: Initdb failure with PG 7.1.3 on RH 7.1...
Previous Message Masaru Sugawara 2001-11-30 14:41:30 Re: 【エクナネット】新サー