Query to PostgreSQL

February 27, 2024

Version updated for yakubique/query-postgresql to version v1.2.

This action is used across all versions by 0 repositories.

Go to the GitHub Marketplace to find the latest changes.

Release notes

query-postgresql

Full Changelog: https://github.com/yakubique/query-postgresql/compare/v1.1...v1.2 Make query to PostgreSQL and return JSON

Usage

For live examples, please see actions

uses: yakubique/query-postgresql@v1.2
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