Hello,
I would like to create a shell script that would populate two variables with
the return of a SELECT statement that would return two attributes...
For example...
#!/bin/bash
SERVER_NAMES=`psql Admin -Upostgres -hMYSERVER -t -c"SELECT servername,
instanceport from server where serverclass = 3 and isactive = 'True' ";`
As you can see, I'm returning the servername "and" the instanceport from the
server table. This will later allow me to create psql commands to connect
to each server dynamically.
I had the script working correctly when I was just running it for the server
name as below...
#!/bin/bash
SERVER_NAMES=`psql Admin -Upostgres -hMYSERVER -t -c"SELECT servername from
server where serverclass = 3 and isactive = 'True' ";`
Does anyone know the easiest way to get both values out of some variables
that I could set?
Later in the script, I'm creating a for loop and iterating through the
server names and would like to build connection strings dynamically with the
results from the select string...
for i in $SERVER_NAMES
do
psql -Upostgres -h$i -p$i -A -t -c"SELECT '$i', '$BATCHTIME', name,
setting, category, short_desc, context, vartype, source, min_val, max_val
FROM pg_settings;" | psql Admin -Upostgres -hMYSERVER -t -c"COPY
serverconfigsetting FROM STDIN WITH DELIMITER '|' NULL AS '';"
echo "Done with $i"
done
As you can see I have "-h$i -p$i" in the script for the host and port.
Again the script worked fine when I just had the [EMAIL PROTECTED] in there...
I know that the current forloop is incorrect specifiying the $i twice but I
just put that in there to show an example of what I was hoping to do... It
would probably be more accessing the array value like -h$i[0:0] -p$i[0:1] in
pseudo code for accessing array values.
Thanks in advance,
Paul
--
View this message in context:
http://www.nabble.com/shell-script-to-populate-array-values-tf2796502.html#a7802638
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
