Skip site navigation (1) Skip section navigation (2)

Delete column

From: Setyo Nugroho <snugroho(at)gmx(dot)net>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Delete column
Date: 2002-11-12 09:56:58
Message-ID: 1037095019.3405.10.camel@see03 (view raw or flat)
Thread:
Lists: pgsql-novice
Hi all,
I failed to delete a column of a table, using these: 
 
db=# ALTER TABLE route DELETE COLUMN plan; 
db=# ALTER TABLE route DROP COLUMN plan;

Adding a column using ALTER TABLE etc .. is possible, what about
deleting it ?

Any help would highly be appreciated.

Regards,
Setyo Nugroho



pgsql-novice by date

Next:From: Henshall, Stuart - Design & PrintDate: 2002-11-12 09:57:33
Subject: Re: Delete column
Previous:From: Manfred KoizarDate: 2002-11-12 09:28:46
Subject: Re: SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group