Connect a Go application to Neon

To connect to Neon from a Go application:

1. Create a Neon project
2. Configure Go project connection settings

Create a Neon project

If you do not have one already, create a Neon project. Save your connection details including your password. They are required when defining connection settings.

To create a Neon project:

1. Navigate to the Projects page in the Neon Console.
2. Click New Project.
3. Specify your project settings and click Create Project.

Configure Go application connection settings

Connecting to Neon requires configuring connection settings in your Go project's .go file.

Specify the connection settings in your .go file, as shown in the following example:

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/lib/pq"
)

func main() {
    connStr := "postgresql://[user]:[password]@[neon_hostname]/[dbname]?sslmode=require"
    db, err := sql.Open("postgres", connStr)
    if err != nil {
        panic(err)
    }
    defer db.Close()

    var version string
    if err := db.QueryRow("select version()").Scan(&version); err != nil {
        panic(err)
    }

    fmt.Printf("version=%s\n", version)
}

You can find your database connection details by clicking the Connect button on your Project Dashboard. For more information, see Connect from any application.