How to set singular name for a table in gorm

Question

type user struct {     ID       int     Username string `gorm:"size:255"`     Name     string `gorm:"size:255"` } 

I want to create a table 'user' using this model. But the table name is automatically set to 'users'. I know it is gorm's default behavior. But I want the table name to be 'user'.

Answer 1

Set method TableName for your struct.

func (user) TableName() string {     return "user" } 

Link: https://gorm.io/docs/models.html#conventions

Answer 2

Gorm has a in-built method for that that will be set in global level so all tables will be singular.

For gorm v1, you could do:

db.SingularTable(true) 

For v2, it's a little more verbose:

db, err := gorm.Open(postgres.Open(connStr), &gorm.Config{     NamingStrategy: schema.NamingStrategy{         SingularTable: true,     }, })