get users by name from postgresql database code example

Example: postgresql get current user name

SELECT current_user;