On Sun, Mar 12, 2000 at 05:57:50PM +0200, Raigo Lukk wrote:
> Hi
>
> > > > alter table tmp add column last text;
>
> I had this same problem, turned out that PostgreSQL don't have
> this feature :-(
>
Upgrade:
ALTER TABLE tablename ADD COLUMN columnname columntype
Has been a feature since version 6.5.X, at least.
> So only way is:
> DROP TABLE and then again CREATE TABLE with all the fields
> you need.
>
This is still needed for DROP COLUMN but not ADD COLUMN.
Ross
--
Ross J. Reedstrom, Ph.D., <[EMAIL PROTECTED]>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
