Re: delete columns from table!

Thanks, it helps!

Tim Barnard wrote:

> Another way SELECT INTO a new table, omitting the column you want to delete.
>
> Tim
>
> ----- Original Message -----
> From: "Patrick Welche" <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
> To: "Fariba Noorbakhsh" <fNoorbakhsh(at)tecways(dot)com>
> Cc: <pgsql-general(at)postgresql(dot)org>
> Sent: Monday, August 13, 2001 7:36 AM
> Subject: Re: [GENERAL] delete columns from table!
>
> > On Mon, Aug 06, 2001 at 05:42:09PM +0200, Fariba Noorbakhsh wrote:
> > > Hi Patrick,
> > >
> > > Do you know how I can drop(delete) a column from a table?! Just a
> column. I don't
> > > think you can do it with Alter table
> > >
> > > Thanks in advance,
> > > Fariba
> >
> > According to the TODO list:
> >
> > COMMANDS
> > ...
> > * ALTER
> > ...
> > o Add ALTER TABLE DROP COLUMN feature [drop]
> >
> >
> > so the way forward may be to
> > pg_dump -t your_table -D your_database > table.txt
> > and have fun editing out all reference to said column from table.txt. Then
> > drop the table and reload from table.txt. YMMV..
> >
> > Cheers,
> >
> > Patrick
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html