Revision 9649
Added by Aaron Marcuse-Kubitza over 11 years ago
| lib/sh/db.sh | ||
|---|---|---|
| 217 | 217 |
|
| 218 | 218 |
alias use_pg='declare prefix=pg_; import_vars; unset prefix' |
| 219 | 219 |
|
| 220 |
fi # load new aliases |
|
| 221 |
if self_being_included; then |
|
| 222 |
|
|
| 220 | 223 |
psql() # usage: [stdin=copy_pstdin_file] psql <<<"cmds, e.g. \copy from pstdin" |
| 221 | 224 |
{
|
| 222 | 225 |
echo_func; kw_params stdin |
| 223 | 226 |
|
| 227 |
use_pg |
|
| 228 |
log+ -2 |
|
| 229 |
local PGHOST="$server"; export PGHOST |
|
| 230 |
local PGUSER="$user"; export PGUSER |
|
| 231 |
local PGPASSWORD="$password"; export PGPASSWORD |
|
| 232 |
local PGDATABASE="$database"; export PGDATABASE |
|
| 233 |
log+ 2 |
|
| 234 |
|
|
| 224 | 235 |
if can_log; then set -- --echo-all --echo-hidden "$@"; fi |
| 225 | 236 |
local redirs=("${redirs[@]}" '10<&0' "0<${stdin:-&20}" '13>&1')
|
| 226 | 237 |
# not 11 (for 13) because it gives a "/dev/fd/11: Bad file descriptor" |
Also available in: Unified diff
lib/sh/db.sh: psql(): set $PG* connection env vars from our connection vars ($server, $user, etc.). use use_pg to import $database so it can be different from $database for MySQL