Command Prompt, Inc.
CURRENT_USER
Practical PostgreSQL
PrevNext

CURRENT_USER

Name

CURRENT_USER -- Returns the current database username.

Synopsis

    CURRENT_USER

Parameters

This function does not accept parameters.

Results

This function returns the name of the current database user.

Description

Use the CURRENT_USER function to retrieve the name of the current user in a string of type name (a 31 character length non-standard type used for storing system identifiers).

Examples

The following example displays the current user logged into testdb:

testdb=# SELECT CURRENT_USER AS myself;
 myself
--------
 jlx
(1 row)
PrevHomeNext
CURRENT_TIMESTAMPUpDECLARE

Powered by Mammoth PostgreSQL
Copyright © 2000-2007 Command Prompt, Inc. All Rights Reserved. All trademarks property of their respective owners.