Hmmm... both are supported in 7.3.x
ALTER TABLE rtfm RENAME f1 to f2 ;
ALTER TABLE rtfm DROP COLUMN f3;
hope it helps.
regds
mallah.
>
> I need to rename and remove columns of a table. Is any new way to accomplish the two tasks in
> 7.3? I have searched the online document and don't see any related information.
>
> Thanks,
>
> Vernon
>
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off
> all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
-----------------------------------------
Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/