Postgres Pro
Downloads
Home   >   mailing lists

Print pg_lsn as a number? - Mailing list pgsql-general

From Scott Stroupe
Subject Print pg_lsn as a number?
Date
Msg-id B7E970C2-6453-4E0C-BD97-22FAD313AF00@kofile.net
Whole thread Raw
Responses Re: Print pg_lsn as a number?  (Andres Freund <andres@anarazel.de>)
Re: Print pg_lsn as a number?  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Tree view 
According to the documentation[1], pg_lsn is a 64-bit integer that's printed as two hex numbers separated by a slash,
e.g.68/1225BB70. Is there a way to get the 64-bit integer in a common numeric representation instead of the peculiar
hex-slash-hexrepresentation? 

Thanks,
Scott

[1] https://www.postgresql.org/docs/current/static/datatype-pg-lsn.html

pgsql-general by date:

Previous
From: Don Seiler
Date:
Subject: Re: Bad performance with cascaded deletes
Next
From: Steve Krenzel
Date:
Subject: Re: Semantics around INSERT INTO with SELECT and ORDER BY.