Writepg
(since EVL 1.3)
Write stdin or <f_in> into <table> of PostgreSQL. If the table is not empty, it is
truncated unless "–append" option is used.
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’.
- Writepg
-
is to be used in EVS job structure definition file.
<f_in>is either input file or flow name. - evl writepg
-
is intended for standalone usage, i.e. to be invoked from command line and reading records from standard input.
EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).
Synopsis
Writepg <f_in> [<schema>.]<table> (<evd>|-d <inline_evd>) [-a|--append] [-b|--dbname=<database>] [-h|--host=<hostname>] [-p|--port=<port>] [-u|--username=<pguser>] [--psql=<psql_options>] [-x|--text-input] evl writepg [<schema>.]<table> (<evd>|-d <inline_evd>) [-a|--append] [-b|--dbname=<database>] [-h|--host=<hostname>] [-p|--port=<port>] [-u|--username=<pguser>] [--psql=<psql_options>] [-x|--text-input] [-v|--verbose] evl writepg ( --help | --usage | --version )
Options
- -d, --data-definition=<inline_evd>
-
either this option or the file
<evd>must be presented. Example: ‘-d 'id int, name string, started timestamp'’ - -a, --append
-
target table is appended, not truncated
- -x, --text-input
-
suppose the input 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:
- -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 than standard port ‘5432’. (This option is provided to ‘psql’ command.)
- --psql=<psql_options>
-
all other options to be provides to psql command. See ‘man psql’ for details.
- -u, --username=<user>
-
either this or environment variable ‘PGUSER’ should be provided, if not, then current system username is used as psql user. If variable ‘PGUSER’ is set, this option has preference. (This option is provided to ‘psql’ command.)