Using GORM, is there a way for me to set a default value as a PostgreSQL function?

go go-gorm
Ben Nichols picture Ben Nichols · Nov 6, 2015 · Viewed 17k times · Source

I want something like:

type User struct {
    ID          int     `sql:"default:<myfunction>"`
}

Is this possible with GORM?

Answer

dave picture dave · Nov 6, 2015

Have you tried it? You can do

time.Time `sql:"DEFAULT:current_timestamp"`

and it will use the "current_timestamp" function. If you want the default to be the string current_timestamp, you would do

time.Time `sql:"DEFAULT:'current_timestamp'"`

So, in short, yes, it is possible. You would just do:

type User struct {
    ID          int     `sql:"DEFAULT:myfunction"`
}

Related questions

Gorm Golang orm associations

I'm using Go with the GORM ORM. I have the following structs. The relation is simple. One Town has multiple Places and one Place belongs to one Town. type Place struct { ID int Name string Town Town } type Town struct { …

Read More
How to Create or Update a record with GORM?

Gorm has a FirstOrCreate method and a FirstOrInit but how to check afterwards if the record was actually created? I like to create a record if it does not exists and if it exists I want to update some fields.

Read More
reflect.Value.Set using unaddressable value

g.GET("/", func(c echo.Context) error { var users []models.User err := db.Find(users).Error if err != nil { fmt.Println(err) } return c.JSON(http.StatusOK, users) }) this is the code for getting and displaying users from table using …

Read More