#!/bin/sh
export PGPASSWORD=PYnuOIXNbkVOvdTL
P="psql -h 127.0.0.1 -U bgar1_delta_com -d bgar1_delta_com_ingredi"
echo "== count"
$P -tA -c "select count(*) from security_provider"
echo "== schema"
$P -tA -c "select column_name from information_schema.columns where table_name='security_provider' order by ordinal_position" | tr '\n' ' '
echo
echo "== rows"
$P -x -c "select * from security_provider" 2>&1 | cut -c1-260 | head -120
