psql_demo.sh

psql_demo.sh

# Demonstrates psql command line client on Ubuntu machines
# See: https://www.postgresql.org/download/linux/ubuntu/

cat $HOME/.pgpass <<EOF
$PGHOST:5432:$PGINST:$PGUSER:$PGPASS
EOF

psql -h $PGHOST -p 5432 -U $PGUSER $PGINST -t -f - <<EOF
drop table primes;
create table primes (
  num int not null primary key,
  txt text
);
insert into primes values (2, 'two');
insert into primes values (3, 'three');
insert into primes values (5, 'five');
insert into primes values (5, 'lima') on conflict (num) do update set txt = 'lima';
select * from primes;
EOF