Skip site navigation (1) Skip section navigation (2)

Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL

From: Robin Iddon <robin(at)edesix(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Date: 2012-03-14 10:54:15
Message-ID: 1331722455.5503.166.camel@elliot (view raw or flat)
Thread:
Lists: pgsql-admin
What do you want to have happen to the timestamp/user?

You can obviously do:

update test set t4 = 9, user = <someuser>, timestamp = <sometimestamp>
where t1 = 001;

I'm assuming you're trying to store the user and timestamp somewhere
else, though?

Robin

On Wed, 2012-03-14 at 12:44 +0200, Khangelani Gama wrote:
>  
> 
> Hi
> 
>  
> 
>  
> 
> Is it possible to have an update query that will specify actions,
> timestamp, user who’s making the update inside the database. Can this
> be done without any script but just in the transaction block 
> 
>  
> 
> Example:
> 
>  
> 
> dbtest=# UPDATE table test set t4 = 9 where t1 = 001 then specify
> user_name,  timestamp() ;
> 
>  
> 
>  
> 
>  
> 
>  
> 
> Thanks in advance
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> C O N F I D E N T I A L I T Y   N O T I C E 
> The contents of and attachments to this e-mail are intended for the
> addressee only, and may contain the confidential information of
> Argility (Proprietary) Limited and/or its subsidiaries. Any review,
> use or dissemination thereof by anyone other than the intended
> addressee is prohibited. If you are not the intended addressee please
> notify the writer immediately and destroy the e-mail. Argility
> (Proprietary) Limited and its subsidiaries distance themselves from
> and accept no liability for unauthorised use of their e-mail
> facilities or e-mails sent other than strictly for business purposes.
> 
>  
> 
> 
> 
> 
> 
> CONFIDENTIALITY NOTICE
> The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited.
> If you are not the intended addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.



In response to

Responses

pgsql-admin by date

Next:From: Khangelani GamaDate: 2012-03-14 11:24:36
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Previous:From: Khangelani GamaDate: 2012-03-14 10:44:54
Subject: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group