Re: [SQL] How do you remove a field from a table?

On Tue, 14 Jul 1998, Danny Rice wrote:
> How do you remove a field from a table?

Hahaha. I wondered the same thing when I first started using
PostgreSQL. Unfortunately, YOU DON'T! PostgreSQL has not yet
implemented that funtion of the ALTER TABLE command. You have to
just create a new table and copy everything over. I think this is in
the FAQ, or it might be in the User's Manual. I personally hope they
implement this soon. It's kind of a pain not having it.
Cheers.
--Dan

-----------------------------------------------------------------------
Daniel G. Delaney The Louisville Times Chorus
Dionysos(at)Dionysia(dot)org www.LouisvilleTimes.org
www.Dionysia.org/~dionysos/ Dionysia Design
ICQ Number: 8171285 www.Dionysia.com/design/
-----------------------------------------------------------------------
I doubt, therefore I might be.