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,
pgsql-novice by date
|Next:||From: Herb Blacker||Date: 2001-10-09 15:26:52|
|Subject: Loading current_user and current_timestamp using COPY|
|Previous:||From: Tom Lane||Date: 2001-10-09 13:57:39|
|Subject: Re: Rules and Views |
pgsql-sql by date
|Next:||From: Stephan Szabo||Date: 2001-10-09 15:38:30|
|Subject: Re: Problem with n to n relation|
|Previous:||From: Alexander Deruwe||Date: 2001-10-09 13:24:00|
|Subject: Linking against null-fields.|