Could somene supply me with a solution or documentation part that i should read?
Can't remember which part it is, but you want one of: SELECT CURRENT_USER; SELECT SESSION_USER;
test=# SELECT CURRENT_USER; current_user -------------- anton (1 row)
test=# SELECT SESSION_USER; session_user -------------- anton (1 row)
This gives the same output. Looks like i should check this with the real operatins to understand the difference or RT*M more.
Sometimes a function may be running with the permissions of its creator rather than the user running it. See the CREATE FUNCTION reference for details.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org