1 files changed, 31 insertions, 0 deletions

diff --git a/util/postgres.go b/util/postgres.go
new file mode 100644
index 0000000..a108446
--- /dev/null
+++ b/util/postgres.go
@@ -0,0 +1,31 @@
+package util
+
+import (
+        "regexp"
+        "strings"
+)
+
+var (
+        pgArrayReg = regexp.MustCompile(`(((?P<value>(([^",\\{}\s(NULL)])+|"([^"\\]|\\"|\\\\)*")))(,)?)`)
+        pgValueIdx int
+)
+
+func init() {
+        for i, subexp := range pgArrayReg.SubexpNames() {
+                if subexp == "value" {
+                        pgValueIdx = i
+                        break
+                }
+        }
+}
+
+func PGArray(array []byte) []string {
+        var results []string
+        matches := pgArrayReg.FindAllStringSubmatch(string(array), -1)
+        for _, match := range matches {
+                s := match[pgValueIdx]
+                s = strings.Trim(s, "\"")
+                results = append(results, s)
+        }
+        return results
+}