Home > mailing lists

JWT decoder - Mailing list pgsql-general

From	Masih Tavassoli
Subject	JWT decoder
Date	August 9, 2021 05:16:12
Msg-id	2138331050.291272.1628475372080@mail.yahoo.com Whole thread Raw
Responses	Re: JWT decoder (Mladen Gogala <gogala.mladen@gmail.com>) Re: JWT decoder (rob stone <floriparob@gmail.com>) Re: JWT decoder ("Daniel Verite" <daniel@manitou-mail.org>)
List	pgsql-general

Tree view

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.eyJzY29wZSI6W10sInN1YiI6Imp1bGllQHNhcHBoaXJlY29udmV5YW5jaW5nLm5ldC5hdSIsImNsaWVudCI6InB4YV9hY19zZXR0c3BsdXMiLCJ1c2VybmFtZSI6Imp1bGllQHNhcHBoaXJlY29udmV5YW5jaW5nLm5ldC5hdSIsImV4cCI6MTU1NDA4NzU2N30.OZwVETCP+HUDsSkudCfa52eQT2Fyt6BgefFpYr5xpJROjZJeVnXtzsU6MS8aHauqyyOwQSz8iG6OC2YjYgrGiZ8YTwTh1uHptNjicyCFmCkh++d0oGdK78ZOKIAvuslW3GX4V13hPUJADzGLkyO8hy01YF9Id4+7GrvmnRRkwPO7C2eUvKTB8pxDAA94Jpw74s4BiNTmm1Uv+56AXqdI8m2KFkLNwGoUR3OSNvsifl5uxBsGGmP4wbgNe/Dy1q2UsL2eBAW/GuWryHGCRz1/PR2jIV1v21ClQ8YLiFAzM3YxHb8m2ngzRynKof+Nw3nZvuafRQ16MV5THz0ahGFYLA'

), '[[:space:]]', ''))))) from dual

But there doesn't seem to be a way doing it in postgres.

Has anyone got any suggesions?

Thanks

Masih

pgsql-general by date:

From: Luca Ferrari
Date: 08 August 2021, 23:17:39
Subject: Re: autovacuum worker started without a worker entry

From: Mladen Gogala
Date: 09 August 2021, 06:24:15
Subject: Re: JWT decoder

JWT decoder - Mailing list pgsql-general

Previous

Next