KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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!
Tags (comma-separated)
Save Edits
Cancel