| From: | Phill Kenoyer <pgsql(at)c0de(dot)net> |
|---|---|
| To: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
| Cc: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: drop column? |
| Date: | 2002-01-23 20:29:05 |
| Message-ID: | 20020123202905.GB16670@home.c0de.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 (jkanter(at)virginia(dot)edu) 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
|jkanter(at)virginia(dot)edu
--
BOFH Reason of the day: not properly grounded, please bury computer
_ | _
(_()(|('.|)('||.|()|`|(
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bangh | 2002-01-23 20:43:29 | Re: drop column? |
| Previous Message | Nick Fankhauser | 2002-01-23 20:25:59 | Re: drop column? |