Postgres SHA256 fingerprints

[York Wangenheim]

Hi there,

Is there anyway to use the SHA256 fingerprint to get a certificate from the Postgres client? 

 E.g, is it possible to do this query: https://crt.sh/?q=522D2806ACF58F58F26524D9DFF2D30B45065C7863CB828579969926344C1724+%09+ in the Postgres client? 

With regards,

York

[r...@sectigo.com]

Hi York.  Try these...

SELECT pem_cert(c.CERTIFICATE) FROM certificate c WHERE digest(c.CERTIFICATE, 'sha256') = E'\\x522D2806ACF58F58F26524D9DFF2D30B45065C7863CB828579969926344C1724';

SELECT x509_print(c.CERTIFICATE) FROM certificate c WHERE digest(c.CERTIFICATE, 'sha256') = E'\\x522D2806ACF58F58F26524D9DFF2D30B45065C7863CB828579969926344C1724';