ALTER TABLE and dropping a column

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: ALTER TABLE and dropping a column
Date: 2002-02-07 22:25:13
Message-ID: 20020207232512.D6766@superfly.archi-me-des.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-02-07 23:22:43 Re: ALTER TABLE and dropping a column
Previous Message Frank Joerdens 2002-02-07 22:04:48 Re: Looking for the correct solution for a generic problem.