Is there any function/stored procedure in PostgreSQL/plpgsql which is same as the javascripts encodeURI?
What does it mean? Javascript have a handy built in function to encode any kind of url:
encodeURI(url) -> returns the encoded url
For example:
encodeURI('http://hu.wikipedia.org/wiki/São_Paulo') -> returns a String which is "http://hu.wikipedia.org/wiki/S%C3%A3o_Paulo"
I looking for exactly the same.
I don't want to encode each parameters separately. I don't want a function like javascript encodeURIComponent which is not the same. The example above results a different output with
encodeURIComponent('http://hu.wikipedia.org/wiki/São_Paulo')
-> "http%3A%2F%2Fhu.wikipedia.org%2Fwiki%2FS%C3%A3o_Paulo"
It's encode the whole string not just the path part. So this is not what I'm looking for. I need a plpgsql function which results equivalent output to javascript function encodeURI.
Thanks!