在GORM中使用Postgres自定义数据类型

 CREATE TABLE "user" ("id" bigserial,
                      "created_at" timestamptz,
                      "updated_at" timestamptz,
                      "deleted_at" timestamptz,
                      "username" varchar(20),unique,
                      "password" varchar(20),
                      "email" varchar(32),unique,
                      "authority" enum('root', 'one', 'two', 'three', 'four'),default:'one',
                      PRIMARY KEY ("id"))
错误: 语法错误 在 "," 或附近的 (SQLSTATE 42601)

CREATE TYPE authority AS ENUM (
    'root',
    'one',
    'two',
    'three',
    'four');

import (
	"database/sql/driver"
)
type Authority string
// 'root', 'one', 'two', 'three', 'four'
const (
	root  Authority = "root"
	one   Authority = "one"
	two   Authority = "two"
	three Authority = "three"
	four  Authority = "four"
)
func (p *Authority) Scan(value interface{}) error {
	*p = Authority(value.([]byte))
	return nil
}
func (p Authority) Value() (driver.Value, error) {
	return string(p), nil
}

type User struct {
	global.Model
	Username  string `gorm:"type:varchar(20)" json:"username" `
	Password  string `gorm:"type:varchar(20)" json:"password"`
	Email     string `gorm:"type:varchar(32)" json:"email" `
	Authority string `gorm:"type:authority" json:"authority"`
}

err = DB.AutoMigrate(&User{})
	if err != nil {
		fmt.Println("数据库创建失败", err)
		return nil
}