Add a trigger in postgres to make a slug

A post in Affill.io, the SaaS I’m making, can have a customizable slug as its URL. But only if the post is made from a subscribed account, if its a free account the slug will be the posts id. If I just make a new row for the free accounts post I woul...