How can I mimic the php urldecode function in postgresql?

Yes you can: CREATE OR REPLACE FUNCTION decode_url_part(p varchar) RETURNS varchar AS $$ SELECT convert_from(CAST(E'\\x' || string_agg(CASE WHEN length(r.m[1]) = 1 THEN encode(convert_to(r.m[1], 'SQL_ASCII'), 'hex') ELSE substring(r.m[1] from 2 for 2) END, '') AS bytea), 'UTF8') FROM regexp_matches($1, '%[0-9a-f][0-9a-f]|.', 'gi') AS r(m); $$ LANGUAGE SQL IMMUTABLE STRICT; This creates a function

[shimooka]

PostgreSQLでurldecode