Print pg_lsn as a number?

From: Scott Stroupe <sstroupe(at)kofile(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Print pg_lsn as a number?
Date: 2018-06-12 16:31:49
Message-ID: B7E970C2-6453-4E0C-BD97-22FAD313AF00@kofile.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-hex representation?

Thanks,
Scott

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Krenzel 2018-06-12 16:37:12 Re: Semantics around INSERT INTO with SELECT and ORDER BY.
Previous Message Don Seiler 2018-06-12 15:51:12 Re: Bad performance with cascaded deletes