FiveTech Support Forums

hi,

how can I to read in my .pgm a value that I have in my .bat file?

Example:

inside file mio.bat

set cValue="1"

inside file mio.pgm

instruction that read cValue of mio.bat

thanks

To read a value from a .bat file into a .pgm file, you'll need to use a combination of batch scripting and PostgreSQL commands. Here's a step-by-step approach:

1. First, in your .bat file (mio.bat), set the value:

set cValue=1

1. Then, you need to pass this value to your PostgreSQL script. You can do this by using environment variables. Modify your .bat file to call the .pgm file and pass the variable:

set cValue=1

psql -f mio.pgm -v cvalue=%cValue%

1. In your .pgm file (mio.pgm), you can now access this value using the :cvalue syntax. Here's an example of how you might use it:

-- mio.pgm

SELECT :cvalue AS imported_value;

This will create a query that selects the value passed from the .bat file.