| 123456789101112131415 |
- #!/usr/bin/env bash
- # Lae keskkonnamuutujad
- source env.sh
- # Kontrolli, kas skeem eksisteerib
- schema_exists=$(psql ${CONNECTION_NAME} -tAc "SELECT 1 FROM information_schema.schemata WHERE schema_name='${destination_schema}';")
- if [[ "$schema_exists" == "1" ]]; then
- echo "Skeem '${destination_schema}' on juba olemas."
- else
- echo "Skeemi '${destination_schema}' ei leitud. Loon skeemi..."
- psql ${CONNECTION_NAME} -c "CREATE SCHEMA ${destination_schema};"
- echo "Skeem '${destination_schema}' on loodud."
- fi
|
