Received: from www.isgenesis.com (adsl-65-68-232-154.dsl.austtx.swbell.net [65.68.232.154]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f99G3Bn08733 for ; Tue, 9 Oct 2001 12:03:11 -0400 (EDT) (envelope-from herbblacker@isgenesis.com) Received: from isgenesis.com (adsl-65-68-232-155.dsl.austtx.swbell.net [65.68.232.155]) by www.isgenesis.com (8.11.6/8.11.2) with ESMTP id f99Fseo23061 for ; Tue, 9 Oct 2001 10:54:40 -0500 Message-ID: <3BC31321.1000807@isgenesis.com> Date: Tue, 09 Oct 2001 10:09:21 -0500 From: Herb Blacker User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.4) Gecko/20010913 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-novice@postgresql.org Subject: Loading current_user and current_timestamp using COPY Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/54 X-Sequence-Number: 2158 I'm trying to load the current_user and current timestamp (as an audit) in a set of data using the COPY FROM... statement. I cannot get the session_user, current_user or user to give me anything but the text itself...I even tried the obsolete getpgusername() and thats exactly what it entered! To get the current_timestamp, I had to use the now() function. The declaration for the fields is: . . updateUserId text DEFAULT current_user, updateTimestamp timestamp DEFAULT current_timestamp, . Am I doing something wrong? Thanks in advance, -- Herb Blacker Database Administrator ReCare, Inc.