ReadPG
Write to stdout or <f_out>
Postgresql <table>
.
Password is taken from $HOME/.pgpass file.
- 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.)