Re: How to rename and drop a column in pg7.3?

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(at)postgresql(dot)org)

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/