pgutil

Documentation

Overview

Package pgutil provides utilities to deal with PostgreSQL specific data types.

Index

• func ParsePgArray(array string) []string
• func ParsePgRow(row string) []string
• func TimestampTZToTime(t string) (time.Time, error)

Functions

func ParsePgArray

func ParsePgArray(array string) []string

ParsePgArray parses the output string from the array type. Regex used: (((?P<value>(([^",\\{}\s(NULL)])+|"([^"\\]|\\"|\\\\)*")))(,)?) Thanks to adharris: https://gist.github.com/adharris/4163702

func ParsePgRow

func ParsePgRow(row string) []string

ParsePgRow a pg row which looks like "(12,\"foo, bar\", 12)" (unquoted)

func TimestampTZToTime

func TimestampTZToTime(t string) (time.Time, error)

TimestampTZToTime converts a pg timestamp with timezone datetime formatted string to a time.Time