URL Decode function

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: URL Decode function
Date: 2021-04-06 04:34:19
Message-ID: CAAY=A79T+2DtCt6pv2AKAnP2Azsb6MPLJxZSV0C3GS=AvjOq9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

In my DB, one of my tables has a field that is URL Encoded (its value is a
URL of course).

For example, the value:
*https://www.cosmohits.com/ListasPopularidad/ListaPopularidad/1-la-superlista
<https://www.cosmohits.com/ListasPopularidad/ListaPopularidad/1-la-superlista>*
is URL Encoded like this:

*https%3A%2F%2Fwww.cosmohits.com
<http://2Fwww.cosmohits.com>%2FListasPopularidad%2FListaPopularidad%2F1-la-superlista*

Is there a PostgreSQL function to URL Decode such field when performing a
SELECT statement? I have not found anything in documentation.

Best regards,
Jorge Maldonado

<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message MichaelDBA 2021-04-06 12:56:10 Re: URL Decode function
Previous Message Sebastien FLAESCH 2021-03-31 15:13:06 Re: Serial sequence name when table/column name in uppercase