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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
