2019-01-16 10:08
浏览 103


I am new at golang. I am trying to write in a specific database schema using GORM and database/sql package. Here is my struct

type Person struct {
Name                string    
Age                 int    

and my function to write in db is:

func writedb(){

psqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+" password=%s dbname=%s sslmode=disable", host, port, user, password, dbname)
    db, err := gorm.Open("postgres", psqlInfo)
    if err != nil {
        fmt.Println("Não conectou-se ao BANCO DE DADOS")
    defer db.Close()


    //t := time.Now()
    //ts := t.Format("2006-01-02 15:04:05")

    db.Create(&Person{Name : "alex", Age: 20})


My db is structured like this databaseName --schemaPeople --schemaVehicle --schemaPublic

When I compile, the data inserted goes to an new table in public schema, I want to insert an row in people schema. What am I doing wrong? Am I declaring the struct wrong? How I set the specific schema??

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

相关推荐 更多相似问题