The following bug has been logged on the website:
Bug reference: 14493
Logged by: Maxandre Ogeret
Email address: maxandreogeret(at)gmail(dot)com
PostgreSQL version: 9.4.1
Operating system: Redhat
Description:
Hello.
When launching a .sql file from batch script with psql command you can't
pass a variable with set.
batch file :
parameter=$1
psql -h XXX -U XXX -d XXX $@ --set foo=$parameter
SQL file :
\COPY ( SELECT * FROM table where id = :'foo') TO 'out.lst' WITH DELIMITER
AS '|' NULL AS 'ISNULL';
This won't work. but \qecho :'foo'
Will work.
Thanks for your reading.