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