Home > mailing lists

URL Decode function - Mailing list pgsql-sql

From	JORGE MALDONADO
Subject	URL Decode function
Date	April 6, 2021 07:34:19
Msg-id	CAAY=A79T+2DtCt6pv2AKAnP2Azsb6MPLJxZSV0C3GS=AvjOq9g@mail.gmail.com Whole thread Raw
Responses	Re: URL Decode function (MichaelDBA <MichaelDBA@sqlexec.com>)
List	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

is URL Encoded like this:

https%3A%2F%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

From: Sebastien FLAESCH
Date: 31 March 2021, 18:13:06
Subject: Re: Serial sequence name when table/column name in uppercase

From: MichaelDBA
Date: 06 April 2021, 15:56:10
Subject: Re: URL Decode function