How to drop column

From: Michael Brusser <michael(at)synchronicity(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to drop column
Date: 2003-03-11 23:06:23
Message-ID: DEEIJKLFNJGBEMBLBAHCIENKCOAA.michael@synchronicity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Postgres 7.2 does not support 'drop column'
One apparent way of handling that seems to create the new table,
copy data from the original one, drop original and rename the new table.
However original table may have foreign keys and dependencies, so I may
not be able to drop it.
Is there a clear path to handle this situation?

Thank you,
Mike.

Browse pgsql-admin by date

  From Date Subject
Next Message Robin Reid 2003-03-11 23:16:08 Help with determining a database's size
Previous Message Christopher Browne 2003-03-11 22:54:52 Re: Largest filesize under Linux