Method insertPg

structable.go:431–445

insertPg runs a postgres-specific INSERT. Unlike the default (MySQL) driver, this actually refreshes ALL of the fields on the Record object. We do this because it is trivially easy in Postgres.

()

// this actually refreshes ALL of the fields on the Record object. We do this
// because it is trivially easy in Postgres.
func (s *DbRecorder) insertPg() error {

	cols, vals := s.colValLists(true, false)
	dest := s.fieldReferences(true)

	q := s.builder.Insert(s.table).Columns(cols...).Values(vals...).
		Suffix("RETURNING " + strings.Join(s.colList(true, false), ","))

	sql, vals, err := q.ToSql()
	if err != nil {
		return err
	}

	return s.db.QueryRow(sql, vals...).Scan(dest...)
}

// Update updates the values on an existing entry.
//