sqlpage.random_string(length)

Introduced in SQLPage 0.7.2.

Returns a cryptographically secure random string of the given length.

Example

Generate a random string of 32 characters and use it as a session ID stored in a cookie:

INSERT INTO login_session (session_token, username) VALUES (sqlpage.random_string(32), :username)
RETURNING 
    'cookie' AS component,
    'session_id' AS name,
    session_token AS value;

Parameters

length

The length of the string to generate.