maxandreogeret(at)gmail(dot)com writes:
> When launching a .sql file from batch script with psql command you can't
> pass a variable with set.
I think the actual issue here has nothing to do with batch files;
rather the problem is that \copy doesn't expand potential variable
references in its arguments. I'm not sure about the compatibility
implications of changing that. In the meantime, perhaps you could
use COPY instead of \copy.
regards, tom lane