Postgresql Tips

select * from table
where d.location = 'POINT(0 0)'::geometry
and d.datum < (timestamp 'now' - interval '1 year')

alter table [table] OWNER to [owner]

Grootte van een jsonb rij:
select pg_column_size(datab) from table;


select json_strip_nulls(row_to_json(t))::jsonb - 'columnname_to_skip'
from table t
where t.id = 'id';