sql2csv

sql2csv

Go library for generating csv files based on SQL queries

Only supporting PostgreSQL

Usage

package main

import (
	"context"
	"github.com/frederikhs/sql2csv"
)

const (
	host     = "db.example.com"
	port     = "5432"
	user     = "example"
	password = "example"
	dbname   = "example"
)

func main() {
	conn, err := sql2csv.NewConnection(context.Background(), user, password, host, port, dbname)
	if err != nil {
		panic(err)
	}
	defer conn.Close(context.Background())

	query, err := sql2csv.NewQuery(context.Background(), "SELECT * FROM public.users LIMIT $1", 10)
	if err != nil {
		panic(err)
	}

	// writes results to ./results.csv
	err = conn.WriteQuery(query, "results.csv")
	if err != nil {
		panic(err)
	}
}