alter table - Mailing list pgsql-general

From Yuri A. Kabaenkov
Subject alter table
Date
Msg-id 1518677747.20011130182256@artofit.com
Whole thread Raw
Responses Re: alter table
List 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@artofit.com


pgsql-general by date:

Previous
From: Masaru Sugawara
Date:
Subject: Re: 【エクナネット】新サー
Next
From: Tom Lane
Date:
Subject: Re: Initdb failure with PG 7.1.3 on RH 7.1...