Principal Software Engineer/Architect, motorcyclist, drummer, and artist
There are times, mostly for logging and debugging, when you have a slice of a given type that you would like to print to a log file or just convert to a CSV of values.
A quick and easy way to convert a slice to a CSV in Golang is to use the json module to Marshal it a JSON encoded array.
package main
import (
"encoding/json"
"fmt"
)
func main() {
ints := []int64{1, 2, 3, Sometimes you are working with a PostgreSQL database with A LOT of tables and looking for tables that contain a sub-string in their name. Following is a query that you can run that will return all of the tables that have the string in their name:
SELECT
table_schema,
table_name
FROM
information_schema.tables
WHERE
table_name LIKE '%<string%'
AND table_schema not in ('information_schema', 'pg_catalog')
AND table_type = 'BASE TABLE'
ORDER BY
table_name, table_schema
;