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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
