Batch file + psql problem

[mattdoughty]

Hi,

I'd like to return the output, or output as a variable, from a pgSQL query that I'm executing through batch file back to the batch file so that it executes a line in particular of the batch file (through a 'goto' command I think).

I manage to execute the query and see the result (in cmd) but am not sure how I can grab that result and use it.

If anybody's got any ideas...?

Thanks,

Matt

[rski]

Hi,

I'd like to return the output, or output as a variable, from a pgSQL query that I'm executing through batch file back to the batch file so that it executes a line in particular of the batch file (through a 'goto' command I think).

I manage to execute the query and see the result (in cmd) but am not sure how I can grab that result and use it.

If anybody's got any ideas...?

Thanks,

Matt

I'm afraid I don't get your problem (probably because of my poor english) but are you looking for something like that

for zm in `psql -t -A -c "select column_name from table_name"`
do
#do something with $zm
done;