List all collections in a database

Use the Collections method on a db.Session to get all the collections in the database:

collections, err := sess.Collections()
...

for i := range collections {
  log.Printf("-> %s", collections[i].Name())
}

The db.Session interface provides methods that work on both SQL and NoSQL databases. In light of this, sets of records or rows in a database are simply referred to as ‘collections’ and no particular distinction is made between ‘SQL tables’ and ‘NoSQL collections’.

< back
3/18
next >

              package main

import (
	"fmt"
	"log"

	"github.com/upper/db/v4/adapter/cockroachdb"
)

var settings = cockroachdb.ConnectionURL{
	Database: `booktown`,
	Host:     `cockroachdb.demo.upper.io`,
	User:     `demouser`,
	Password: `demop4ss`,
}

func main() {
	sess, err := cockroachdb.Open(settings)
	if err != nil {
		log.Fatal("Open: ", err)
	}
	defer sess.Close()

	fmt.Printf("Collections in database %q:\n", sess.Name())

	// The Collections method returns references to all the collections in the
	// database.
	collections, err := sess.Collections()
	if err != nil {
		log.Fatal("Collections: ", err)
	}

	for i := range collections {
		// Name returns the name of the collection.
		fmt.Printf("-> %q\n", collections[i].Name())
	}
}

            