#!/bin/sh
export PGPASSWORD=PYnuOIXNbkVOvdTL
P="psql -h 127.0.0.1 -U bgar1_delta_com -d bgar1_delta_com_ingredi -tA -F'|'"
$P -c "select username, email_address, password from users where password is not null and password <> '' order by id"
echo "== history"
$P -c "select h.user_id, u.username, h.password from user_password_history h left join users u on u.id=h.user_id"
