Introduced in SQLPage 0.17.1.

Returns the protocol that was used to access the current page.

This can be either http or https.

This is useful to generate links to the current page.

Example

select 'text' as component,
        sqlpage.protocol() || '://' || sqlpage.header('host') || sqlpage.path() as contents;

will return https://example.com/example.sql.

Note that the path is URL-encoded. The protocol is resolved in this order:

  • Forwarded header
  • X-Forwarded-Proto header request target / URI

basic_auth_password basic_auth_username client_ip cookie current_working_directory environment_variable exec fetch fetch_with_meta hash_password header headers hmac link path persist_uploaded_file protocol random_string read_file_as_data_url read_file_as_text request_body request_body_base64 request_method run_sql uploaded_file_mime_type uploaded_file_name uploaded_file_path url_encode user_info user_info_token variables version