postgresql

Database administration via psql and pg_* utilities.

10 templates 7 bound Database active
admin: 3 info: 3 monitor: 4

Actions

ActionCategoryDescriptionParamsCommand TemplateFlags
queryinfoExecute SQL querydb_host, db_name, sqlpsql -h {db_host} -d {db_name} -c '{sql}'
3-layer composition
INTERFACE#ActionDef & { name: "query", category: "info" }
PROVIDERcommand_template: "psql -h {db_host} -d {db_name} -c '{sql}'"
params: { db_host: from_field: "db_host", db_name: from_field: "db_name", sql: default: "" }
db_listinfoList all databasesdb_hostpsql -h {db_host} -lidempotent
3-layer composition
INTERFACE#ActionDef & { name: "db_list", category: "info" }
PROVIDERcommand_template: "psql -h {db_host} -l"
params: { db_host: from_field: "db_host" }

Import

import "quicue.ca/template/postgresql/patterns"

actions: patterns.#upostgresqlRegistry

JSON-LD

{
  "@id": "https://quicue.ca/project/quicue-postgresql",
  "@type": "quicue:Provider",
  "quicue:providerName": "postgresql",
  "quicue:category": "database",
  "quicue:actionCount": 10
}