verify_db.sh
500 Bytes
#!/bin/bash
echo "Verificando base de datos en 192.168.1.254..."
docker exec proyecto-postgres-1 sh -c 'PGPASSWORD=x25yvaga2017 psql -h 192.168.1.254 -U postgres -c "SELECT datname FROM pg_database WHERE datname ILIKE '\''sigemweb'\'';"'
echo "Verificando tabla entidades en 192.168.1.254..."
docker exec proyecto-postgres-1 sh -c 'PGPASSWORD=x25yvaga2017 psql -h 192.168.1.254 -U postgres -d sigemweb -c "SELECT table_name FROM information_schema.tables WHERE table_name ILIKE '\''entidades'\'';"'