Postgres Pro
Downloads
Home   >   mailing lists

ALTER TABLE and dropping a column - Mailing list pgsql-sql

From Frank Joerdens
Subject ALTER TABLE and dropping a column
Date
Msg-id 20020207232512.D6766@superfly.archi-me-des.de
Whole thread Raw
Responses Re: ALTER TABLE and dropping a column
List pgsql-sql
Tree view 
7.1 at least doesn't seem to support a 'DROP COLUMN' command as in

ALTER TABLE foo DROP COLUMN bar;

Is there a way to do that manually and safely, e.g. by manipulating
pg_class or pg_attribute? I found a couple of threads about it dating
from way back in summer 2000 and early 2001, but nothing conclusive.

Thanks, Frank

pgsql-sql by date:

Previous
From: Frank Joerdens
Date:
Subject: Re: Looking for the correct solution for a generic problem.
Next
From: "Josh Berkus"
Date:
Subject: Re: ALTER TABLE and dropping a column