add offer show view
postgres in prod