psql batch file question - Mailing list pgsql-general

Hi List,

I’m trying to write a batch file that executes a query in PostgreSQL. Depending on the output of the query, the batch file does one of two things, jumps to a line that has a command to export a table from PostgreSQL, or calls another batch file, which copies some files.

What proving difficult is how to handle the output of the query. Should I declare the output as a variable and somehow use that? Currently, the output is:

Expanded display is on.

-[ RECORD 1 ]------

ta_id_vacia | DATA

I’d like to be able to use ‘DATA’ as a variable to call one command or the other.

Has anybody got any ideas?

Thanks!

Matt

PS. Below I’ve copied the current state of the bat.

rem %1 database - %2 scheme

echo. IF \x \\select count(*) from function01('%2', '[table]') | psql %1 [user_name]==DATA goto data

echo.

:copy

echo. call copy_bat.bat [table]

:data

echo. pgsql2shp.exe -h localhost -u [user_name] -f [dbase_name] "[scheme]".[table] querystring

:end