util

util / PostgreSQL / 1.0.0

README.md

Overview

Query a PostgreSQL Database which has been preconfigured via util/PostgreSQLConfig

Usage

Input: bare query string

Any valid SQL query (note that BLOBs or very long result sets may return too much data to transfer; use of LIMIT is encouraged)

"Select Firstname, Lastname from Employees LIMIT 100"

Input: query

ParameterDescription
queryAny valid SQL
{
	"query": "Select Firstname, Lastname from Employees LIMIT 100"
}

Input: query on a specific namespace

util/PostgreSQLConfig supports storing different configuration files, referred to as namespaces

ParameterDescription
namespaceAlphanumeric namespace defined in via PostgreSQLConfig
queryAny valid SQL
{
	"namespace": "staging",
	"query": "Select Firstname, Lastname from Employees LIMIT 100"
}

Output

Query results as multidimensional Array

[
  ["Jane", "Doe"],
  ["Jon", "Doe"]
]