explicit types for postgres