query-postgresql

Make query to PostgreSQL and return JSON

Usage

For live examples, please see actions

uses: yakubique/[email protected]
with:
  query: |
    select true as result
  host: ${{ env.PG_HOST }}
  port: ${{ env.PG_PORT }}
  username: ${{ env.PG_USER }}
  password: ${{ env.PG_PWD }}
  db: ${{ env.PG_DB }}
  ssl: 'false'

Inputs

INPUT	TYPE	REQUIRED	DEFAULT	DESCRIPTION
db	string	true		PostgreSQL db
host	string	true		PostgreSQL host
username	string	true		PostgreSQL username
password	string	true		PostgreSQL password
port	string	true	"5432"	PostgreSQL port (default: 5432)
query	string	true		SQL query (query file if from_file=true)
ssl	string	false	"true"	SSL enabled (default: 'true')
from_file	string	false		Read query from file (default: 'false')
to_file	string	false		Save result to file (default: 'false')

Outputs

OUTPUT	TYPE	DESCRIPTION
count	string	Rows count
result	string	PostgreSQL response OR path to file

---