That was not the question, the question is how do you decode base64url (not base64) in postgres sql?
On Monday, August 9, 2021, 02:08:44 PM GMT+10, rob stone <floriparob@gmail.com> wrote:
Hello,
On Mon, 2021-08-09 at 02:16 +0000, Masih Tavassoli wrote: > Hi experts, > > I am trying to find a way to decode a URL request header and extract > its JSON fields in postgreql . > > I can do this in Oracle sql using > > select (utl_raw.cast_to_varchar2 (utl_encode.base64_decode( > utl_raw.cast_to_raw (regexp_replace ( ( > 'eyJhbGciOiJSUzI1NiIsImtpZCI6InBhLWFwaS1zaWduIn0.eyJzY29wZSI6W10sInN1 > YiI6Imp1bGllQHNhcHBoaXJlY29udmV5YW5jaW5nLm5ldC5hdSIsImNsaWVudCI6InB4Y > V9hY19zZXR0c3BsdXMiLCJ1c2VybmFtZSI6Imp1bGllQHNhcHBoaXJlY29udmV5YW5jaW > 5nLm5ldC5hdSIsImV4cCI6MTU1NDA4NzU2N30.OZwVETCP+HUDsSkudCfa52eQT2Fyt6B > gefFpYr5xpJROjZJeVnXtzsU6MS8aHauqyyOwQSz8iG6OC2YjYgrGiZ8YTwTh1uHptNji > cyCFmCkh++d0oGdK78ZOKIAvuslW3GX4V13hPUJADzGLkyO8hy01YF9Id4+7GrvmnRRkw > PO7C2eUvKTB8pxDAA94Jpw74s4BiNTmm1Uv+56AXqdI8m2KFkLNwGoUR3OSNvsifl5uxB > sGGmP4wbgNe/Dy1q2UsL2eBAW/GuWryHGCRz1/PR2jIV1v21ClQ8YLiFAzM3YxHb8m2ng > zRynKof+Nw3nZvuafRQ16MV5THz0ahGFYLA' > ), '[[:space:]]', ''))))) from dual > > > > But there doesn't seem to be a way doing it in postgres. > > Has anyone got any suggesions? > > Thanks > Masih
>
Have a look at the orafce extension on github. It handles "select from dual", etc.