EVL

Table of Contents


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

Copyright © 2017–2020 EVL Tool, s.r.o.

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.

ReadPG

Write to stdout or <f_out> Postgresql <table>.

ReadPG

is to be used in EVS job structure definition file. <f_out> is either output file or flow name.

evl readpg

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

ReadPG
  [<database>.]<table> <f_out> (<evd>|-d <inline_evd>) [-y|--text-output]
  [--columns=<col_name>[,<col_name>] | --query=<query>]
  [--dbname=<database>] [--host=<hostname>] [--port=<port>] [--username=<pguser>]

evl readpg
  [<database>.]<table> (<evd>|-d <inline_evd>) [-y|--text-output]
  [--columns=<col_name>[,<col_name>] | --query=<query>]
  [--dbname=<database>] [--host=<hostname>] [--port=<port>] [--username=<pguser>]
  [--verbose]

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

Options

-d, --data-definition=<inline_evd>

either this option or the file <evd> must be presented. Example: -d ’id int, user_id string(6) enc=iso-8859-1’

--columns=<column_name>[,<column_name>]

get only specified columns from the table. Example: –columns="id,name,value"

--query=<query>

Use SQL <query> instead of reading whole table. With this option <table> might be an empty string.

-y, --text-output

write the output as text, not binary

Standard options:

--help

print this help and exit

--usage

print short usage information and exit

-v, --verbose

print to stderr info/debug messages of the component

--version

print version and exit

’psql’ options:

--dbname=<database>

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

--host=<hostname>

either this or environment variable PGHOST should be provided when connecting to other host than localhost. If both PGHOST and this option is used, then this option’s value is used. (This option is provided to ’psql’ command.)

--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.)

--username=<pguser>

either this or environment variable PGUSER should be provided, if not, then current system username is used as psql user. If both PGUSER and this option is used, then this option is used. (This option is provided to ’psql’ command.)