postgres=# select cast(extract(epoch from now()) as bigint) as my_var \gset
postgres=# \echo :my_var
1609133432
postgres=# \echo view:my_var
view1609133432