Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- set -e
- set -u
- PSQL=/usr/bin/psql
- DB_USER=myuser
- DB_HOST=myhost
- DB_NAME=mydb
- $PSQL \
- -X \
- -h $DB_HOST \
- -U $DB_USER \
- -c "select username, password, first_name, last_name from users" \
- --single-transaction \
- --set AUTOCOMMIT=off \
- --set ON_ERROR_STOP=on \
- --no-align \
- -t \
- --field-separator ' ' \
- --quiet \
- $DB_NAME | while read -a Record ; do
- username=${Record[0]}
- password=${Record[1]}
- first_name=${Record[2]}
- last_name=${Record[3]}
- echo "USER: $username $password $first_name $last_name"
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement