EVL – ETL Tool

Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

Runpg

(since EVL 2.0)

Run SQL or psql commands from stdin or <f_in> and write result into stdout or <f_out>. It returns output from ‘psql’ as is, so for quering the table to get formatted EVL output use ‘Readpg’ or ‘evl readpg’.

Password is taken:

from file ‘$EVL_PASSFILE’, which is by default ‘$HOME/.evlpass’,
from file ‘$PGPASSFILE’, which is by default ‘$HOME/.pgpass’.

When such file has not permissions 600, it is ignored! For details see ‘evl-password’.

Runpg: is to be used in EVS job structure definition file. <f_out> is either output file or flow name.
evl runpg: is intended for standalone usage, i.e. to be invoked from command line and writing records to standard output.

EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).

Synopsis

Runpg
  <f_in> <f_out>
  [-b|--dbname=<database>] [-h|--host=<hostname>] [-p|--port=<port>]
  [-u|--username=<pguser>] [--psql=<psql_options>]

evl runpg
  [-b|--dbname=<database>] [-h|--host=<hostname>] [-p|--port=<port>]
  [-u|--username=<pguser>] [--psql=<psql_options>]
  [-v|--verbose]

evl runpg
  ( --help | --usage | --version )

Options

Standard options:

--help: print this help and exit
--usage: print short usage information and exit
--version: print version and exit

’psql’ options:

-b, --dbname=<database>

either this or environment variable ‘PGDATABASE’ should be provided, if not, then current system username is used as psql database. If also ‘PGDATABASE’ environment variable is set, this option has preference. (This option is provided to ’psql’ command.)

-h, --host=<hostname>

either this or environment variable ‘PGHOST’ should be provided when connecting to other host than localhost. If also ‘PGHOST’ variable is set, this option has preference. (This option is provided to ‘psql’ command.)

-p, --port=<port>

either this or environment variable ‘PGPORT’ should be provided when using other then standard port ‘5432’. (This option is provided to ‘psql’ command.)

--psql=<psql_options>

by default it runs ‘psql’ command behind with these options:

``--no-align --quiet --tuples-only --set=\"ON_ERROR_STOP=1\"``

If any other option is needed, specify <psql_options>. See ‘man psql’ for details.

-u, --username=<pguser>