The sqlpage.protocol function

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 cookie current_working_directory environment_variable exec fetch hash_password header link path persist_uploaded_file protocol random_string read_file_as_data_url read_file_as_text request_method run_sql uploaded_file_mime_type uploaded_file_name uploaded_file_path url_encode variables version