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
headerX-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