Andy Gimblett <[EMAIL PROTECTED]> writes:
> Question: is there any way to use environment variables (or something
> similar) in my saved SQL code, and have them expanded at runtime?
Only by preprocessing the script. Have you considered something like
cat <<EOF
... WHERE $foo = ...
EOF | psql ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
