Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package main
- import (
- "database/sql"
- "fmt"
- _ "github.com/lib/pq"
- )
- const (
- DB_USER = "postgres"
- DB_PASSWORD = "postgres"
- DB_NAME = "users"
- )
- func main() {
- dbinfo := fmt.Sprintf("user=%s password=%s dbname=%s sslmode=disable",
- DB_USER, DB_PASSWORD, DB_NAME)
- db, err := sql.Open("postgres", dbinfo)
- checkErr(err)
- defer db.Close()
- sqlStatement := `
- INSERT INTO basictable(firstCol,secondCol)
- VALUES ("Yellow", "Colour")`
- _, err = db.Exec(sqlStatement)
- if err != nil {
- panic(err)
- }
- first := "Yellow"
- second := "Colour"
- sqlStatement := `
- INSERT INTO basictable(firstCol,secondCol)
- VALUES (first,second)`
- _, err = db.Exec(sqlStatement)
- if err != nil {
- panic(err)
- }
Add Comment
Please, Sign In to add comment