### Install scany Go Library

Source: https://github.com/georgysavva/scany/blob/master/README.md

This command uses the Go module system to download and install the scany library into your project's dependencies.

```bash
go get github.com/georgysavva/scany/v2
```

--------------------------------

### Scan with pgx in Go

Source: https://github.com/georgysavva/scany/blob/master/README.md

Illustrates how to use the `pgxscan` package with the `pgx` library's native interface. It shows connecting to a database using `pgxpool.New` and using `pgxscan.Select` to scan query results into a slice of structs, similar to the `database/sql` example.

```go
package main

import (
	"context"

	"github.com/jackc/pgx/v5/pgxpool"

	"github.com/georgysavva/scany/v2/pgxscan"
)

type User struct {
	ID    string
	Name  string
	Email string
	Age   int
}

func main() {
	ctx := context.Background()
	db, _ := pgxpool.New(ctx, "example-connection-url")

	var users []*User
	pgxscan.Select(ctx, db, &users, `SELECT id, name, email, age FROM users`)
	// users variable now contains data from all rows.
}
```

--------------------------------

### Scan with database/sql in Go

Source: https://github.com/georgysavva/scany/blob/master/README.md

Demonstrates how to use the `sqlscan` package with the standard `database/sql` library. It shows how to open a database connection, define a struct to hold the data, and use `sqlscan.Select` to scan multiple rows from a query into a slice of structs.

```go
package main

import (
	"context"
	"database/sql"

	"github.com/georgysavva/scany/v2/sqlscan"
)

type User struct {
	ID    string
	Name  string
	Email string
	Age   int
}

func main() {
	ctx := context.Background()
	db, _ := sql.Open("postgres", "example-connection-url")

	var users []*User
	sqlscan.Select(ctx, db, &users, `SELECT id, name, email, age FROM users`)
	// users variable now contains data from all rows.
}
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.