Re: drop column

Amen.

>Unfortunately, Postgres' greatest shortcoming (IMHO) is the inability to
>change table definitions much after creation. To effect any column changes
>besides DEFAULT clauses and indexing (and a few other options), you have to
>drop and re-create the table.
>
>Keary Suska
>Esoteritech, Inc.
>"Leveraging Open Source for a better Internet"
>
> > From: Peter Pilsl <pilsl(at)goldfisch(dot)at>
> > Date: Thu, 18 Oct 2001 10:44:34 +0200
> > To: postgres mailinglist <pgsql-general(at)postgresql(dot)org>
> > Subject: [GENERAL] drop column
> >
> > is there a trick to drop a column in a table ? or do I need to
> > recreate the table and drop the old one ?
> >
> > thnx,
> > peter
> >
> > --
> > mag. peter pilsl
> >
> > phone: +43 676 3574035
> > fax : +43 676 3546512
> > email: pilsl(at)goldfisch(dot)at
> > sms : pilsl(at)max(dot)mail(dot)at
> >
> > pgp-key available
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html