functions available using RIS Lsub job for postgres

test_pgpass <path to pgpass file>

simple test to validate postgres pgpass file.

run_job <connection index> <path to sql script> <devops ticket #> <ignore errors(1 to enable)>

provides a execution plan for running sql against the rdc postgres databases.

show_rdc_env

dumps the relative environment variables for processing RDC tasks.

log_test <path to log file>

Tests a log file for Errors, Warning and other artifacts that may be logged while processing sql scripts.

list_connections

Safely lists postgres connection available in .pgpass file set with $PGPASSFILE environment variable.

set_connection <index value from list_connections>

Sets the psql environment variables to run sql script tasks.