help??? Now I can't drop a renamed column....

From: "Robert Chalmers" <robert(at)chalmers(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>, <sql(at)chalmers(dot)com(dot)au>
Subject: help??? Now I can't drop a renamed column....
Date: 1999-06-01 22:21:38
Message-ID: 009f01beac7d$1e86e900$1a6001cb@chalmers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ok, ok...

I'm beginning to see some limitations here.

Can't MODIFY a column name. as in

ALTER TABLE tablename MODIFY existingColumnName CHAR( 24 );

So tried RENAME, and ADD COLUMN,

and ended up with ISBN and XSBN

fine. Now how do I get rid of XSBN.??????

Thanks for any pointers
Bob

--- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive!
4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of
the
original DJ's - back on air - and supporting not only the original Vets, in
comprehensive AFVN Archives, but putting together segments for the fighting
men and
women of todays services all around the world. World Music, for people of
the world.

Browse pgsql-sql by date

  From Date Subject
Next Message Zalman Stern 1999-06-01 23:37:48 Re: [SQL] Column name's length
Previous Message Pham, Thinh 1999-06-01 22:05:10 RE: [SQL] Column name's length