Re: Delete COLUMN data

Поиск
Список
Период
Сортировка
От smiley2211
Тема Re: Delete COLUMN data
Дата
Msg-id 12073910.post@talk.nabble.com
обсуждение исходный текст
Ответ на Delete COLUMN data  (smiley2211 <smiley2211@yahoo.com>)
Список pgsql-admin
hmmm...

I was just thinking...maybe using UPDATE to NULL field value would be an
option....

Update tblname set field1 = NULL;

Thanks...Michelle


smiley2211 wrote:
>
> Hello all,
>
> I need to DELETE all the DATA from 3 columns in my table...what is the
> BEST way to handle this???  I don't want to DROP the columns just clear
> out ALL the data in those 3 fields...
>
> Thanks...Michelle
>

--
View this message in context: http://www.nabble.com/Delete-COLUMN-data-tf4242917.html#a12073910
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Igor Neyman"
Дата:
Сообщение: Re: Delete COLUMN data
Следующее
От: smiley2211
Дата:
Сообщение: Re: Delete COLUMN data