URL-encoding VARCHAR and TEXT values in PostgreSQL

Question

Are there any well-known PL functions/libraries for extending a PostgreSQL (9.4.1) database with URL encoding (also known as percent encoding) capabilities?

Here's an example of the intended functionality:

Input string: International donor day: give blood for a good cause!
Output string: International%20donor%20day%3A%20give%20blood%20for%20a%20good%20cause%21

I guess an alternative would be to roll out my own implementation, since AFAIK there is currently no built-in way of doing this.

Are you aware that it is possible to use some languages like Python: plpython? — Clodoaldo Neto
– Clodoaldo Neto, Commented Jun 10, 2015 at 17:14
@ClodoaldoNeto: indeed - I was just thinking that maybe there's a popular/universally accepted set of functions out there that I could use straight out of the box. I suppose that if I don't come across anything better, I will indeed have to write something myself (preferably using a high level PL like plpython). — Priidu Neemre
– Priidu Neemre, Commented Jun 10, 2015 at 19:56

Craig Ringer · Accepted Answer · 2015-06-11 04:56:36Z

3

This is trivial to do in an external PL,e.g.

CREATE LANGUAGE plpythonu;

CREATE OR REPLACE FUNCTION urlescape(original text) RETURNS text LANGUAGE plpythonu AS $$
import urllib
return urllib.quote(original);
$$
IMMUTABLE STRICT;

answered Jun 11, 2015 at 4:56

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Priidu Neemre Over a year ago

Thanks! That's exactly what I needed. Note to anyone else reading this: In Python 3 the module hierarchy has been redesigned, so for plpython3u functions, use urllib.parse.quote(original) instead.

Collectives™ on Stack Overflow

URL-encoding VARCHAR and TEXT values in PostgreSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related