Re: Delete COLUMN data

From: smiley2211 <smiley2211(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Delete COLUMN data
Date: 2007-08-09 14:55:17
Message-ID: 12073910.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message smiley2211 2007-08-09 16:12:09 Re: Delete COLUMN data
Previous Message Igor Neyman 2007-08-09 14:50:18 Re: Delete COLUMN data