Library > Products > Pervasive PSQL > Pervasive PSQL v9 SP2 (9.5) > SQL Engine Reference > SQL Syntax Reference > USER

PreviousSQL Engine Reference (v9 SP2 (9.5) revision 1) Next

USER

Chapter contents

Remarks

The USER keyword returns the current user name (such as Master) for each row returned by the SELECT restriction.

Example 

The following examples return the user name from the 
course table. 
SELECT USER FROM course  
		-- returns 145 instances of Master (the table contains 145 rows) 
SELECT DISTINCT USER FROM course  
		-- returns 1 instance of Master

See Also

SELECT

SET SECURITY

Chapter contents
Book contents

Prev topic: UPDATE (positioned)
Next topic: WHILE