http://beego.me/docs/Models_Overview simple usage in postgres

example.go

package main

import (
	"fmt"
	"github.com/astaxie/beego/orm"

	_ "github.com/lib/pq"
)

// Model Struct
type User struct {
	Id   int
	Name string `orm:"size(100)"`
}

func init() {
	// register model
	orm.RegisterModelWithPrefix("test_", new(User))

	orm.RegisterDriver("postgres", orm.DR_Postgres)

	// set default database
	orm.RegisterDataBase("default", "postgres", "db=orm_test sslmode=disable", 30)

	orm.RunCommand()
}

func main() {
	o := orm.NewOrm()

	user := User{Name: "slene"}

	// insert
	id, err := o.Insert(&user)
	fmt.Printf("ID: %d, ERR: %v\n", id, err)

	// update
	user.Name = "astaxie"
	num, err := o.Update(&user)
	fmt.Printf("NUM: %d, ERR: %v\n", num, err)

	// read one
	u := User{Id: user.Id}
	err = o.Read(&u)
	fmt.Printf("ERR: %v\n", err)

	// delete
	num, err = o.Delete(&u)
	fmt.Printf("NUM: %d, ERR: %v\n", num, err)
}

results

$ go build example.go

$ ./example orm syncdb -force -v
drop table `test_user`
    DROP TABLE IF EXISTS "test_user"

create table `test_user`
    -- --------------------------------------------------
    --  Table Structure for `main.User`
    -- --------------------------------------------------
    CREATE TABLE IF NOT EXISTS "test_user" (
        "id" serial NOT NULL PRIMARY KEY,
        "name" varchar(100) NOT NULL
    );

$ ./example
ID: 1, ERR: <nil>
NUM: 1, ERR: <nil>
ERR: <nil>
NUM: 1, ERR: <nil>