How to create bigint unsigned?

Question

PostgreSQL

Greetings!
How to set a bigint unsigned field in postgresql so that the range is
0 to 18446744073709551615
because if you set signed the range will be -9223372036854775808 to 9223372036854775807
.

Answer 1

Make an offset by a constant = 9223372036854775807, i.e. subtract from the value. Then add the same constant to get the value.
If they are only for viewing purposes, keep them in text.