This is something I have been wanting for a long time. The ability to
update or drop a column from a table.
Right now you have to select the columns you want into a temp table and
drop the working table and rename the temp table to the working table.
|On 020123 12:15
|Jodi Kanter ([EMAIL PROTECTED]) wrote the following...
|
|I cannot seem to locate any documentation about removing a column that I just added
|to a table. There is no data in that particular column but there is in the rest of
|the table.
|Can I remove this column or will I need to drop the entire table and restore from
|backup?
|Thanks
|Jodi
|_______________________________
|Jodi L Kanter
|BioInformatics Database Administrator
|University of Virginia
|(434) 924-2846
|[EMAIL PROTECTED]
--
BOFH Reason of the day: not properly grounded, please bury computer
_ | _
(_()(|('.|)('||.|()|`|(
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
