gen-id.sql

with x as (
  select clock_timestamp() as t,
         gen_random_bytes(3) as r,
         1503576000 as offset
),
id as (
  select 
      (((extract(epoch from t) - offset) * 1000)::int8 << 24) |
      (get_byte(r, 0) | (get_byte(r, 1) << 8) | (get_byte(r, 2) << 16)) as id
  from x
)
select id, encode(int8send(id), 'base64')
from id;