[ADMIN] Delete COLUMN data

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.

Re: [ADMIN] Delete COLUMN data

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 t

Re: [ADMIN] Delete COLUMN data

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)---

[ADMIN] Dump & Load a database???

Hello all, I am new to POSTGRESQL and I am trying to dump and load a database...using the steps below I get DUP errors when trying to LOAD the file into an existing database... Do I have to DROP \ recreate and load the target database (this is what I currently do)? is there a way to just do an

[ADMIN] Postgres User Password File????

Hello all, Where do I find the PASSWORDs for users on Postgresql??? It seems connections are failing because user PROOT's password is not correct - where do I find out what it's set to - do I need to change it??? DataObjects_Users : CONNECT : a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB

Re: [ADMIN] Postgres User Password File????

Yep, I can connect LOCALLY with no problem...it's when I come through an application using this user that I have the connection issue. Thanks...Michelle -- View this message in context: http://www.nabble.com/Postgres-User-Password-File-tf4402207.html#a12559172 Sent from the PostgreSQL - ad

[ADMIN] Postgres User Password File????

Hello all, Where do I find the PASSWORDs for users on Postgresql??? It seems connections are failing because user PROOT's password is not correct - where do I find out what it's set to - do I need to change it??? DataObjects_Users : CONNECT : a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB

[ADMIN] Database Restore - time of last occurrence

Hello all, Is there a way to tell when was the LAST time a database was restored? I checked the pg_database system table but I'm not sure what 'datfrozenxid' means or if it means anything SELECT datname, age(datfrozenxid) FROM pg_database; Thanks...Michelle. -- View this message in contex

[ADMIN] Postgresql New login - password expiration???

Hello all, I've created a new Postgresql login and I set an expiration date on the account 'VALID until xx-xx-xxx'...will this require the user to CHANGE his password at expiration or will it DISABLE the user account??? Also, how do I set password expiration on new accounts??? ---I want them to