Loading current_user and current_timestamp using COPY

From: Herb Blacker <herbblacker(at)isgenesis(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Loading current_user and current_timestamp using COPY
Date: 2001-10-09 15:09:21
Message-ID: 3BC31321.1000807@isgenesis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Herb Blacker 2001-10-09 15:26:52 Loading current_user and current_timestamp using COPY
Previous Message Tom Lane 2001-10-09 13:57:39 Re: Rules and Views

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-10-09 15:38:30 Re: Problem with n to n relation
Previous Message Alexander Deruwe 2001-10-09 13:24:00 Linking against null-fields.