show_redshift_schemas.go

package main

import (
        "fmt"

        "github.com/jinzhu/gorm"
        _ "github.com/lib/pq"
)

type Schema struct {
        Nspname string
}

func main() {
        // FORMAT: postgres://user:pass@host:port/dbname
        var conninfo string = "postgres://user:pass@hoge.redshift.amazonaws.com:5439/db_name"
        db, err := gorm.Open("postgres", conninfo)
        if err != nil {
                panic(err)
        }
        defer db.Close()

        schemas := []Schema{}
        err = db.Debug().Table("pg_namespace").Order("nspname").Limit(10).Find(&schemas).Error
        if err != nil {
                panic(err)
        }

        for _, schema := range schemas {
                fmt.Println(schema.Nspname)
        }
}