postgresql drop a column?

[bitsy_]

i want to delete a column named column10 in my table because it has no use...how do i do this in postgresql?<br />

 

[vassdoki]

ALTER TABLE DROP COLUMN column_name;
where column_name is column10 in your case.
I think you need at least 7.3 version for this command.
If your postgres is older, then dump your table, modify the text file, and read it back.