THANKS ALL FOR YOUR REPLIES...THIS WORKED JUST FINE.
--
View this message in context:
http://www.nabble.com/Delete-COLUMN-data-tf4242917.html#a12075308
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
---(end of broadcast)---
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 w
It is called "update":
UPDATE SET = NULL, = NULL, =
NULL;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of smiley2211
Sent: Thursday, August 09, 2007 10:27 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Delete COLUMN data
Hello all,
How about:
UPDATE table_name SET column1 = NULL, column2 = NULL, column3 = NULL
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of smiley2211
> Sent: Thursday, August 09, 2007 10:27 AM
> To: pgsql-admin@postgresql.org
> Subje
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.
