Authorization

You are looking at an older version of the documentation. The latest version is found here.

To control authorization, you can use the SET statement.

SET PASSWORD

This statement allows to change connection credentials, but does not perform a  re-authentication:

SET PASSWORD 'someval';;

SET SESSION AUTHORIZATION

This statement performs a reauthentication given the credentials currently set on the connection:

SET SESSION AUTHORIZATION 'newuser';;