variable assignment while NOT in interactive mode

[xo]

variable assignment while NOT in interactive mode

[kenshaw]

You're using \prompt (not possible in non-interactive mode). Use \set instead. If you need to pass values before the script is executed, then you can use usql --set NAME=VALUE:

$ usql --set FOO=BAR
Type "help" for help.

(not connected)=> \set
FOO = 'BAR'
(not connected)

[kenshaw]

So -- an update, and my apologies for closing this previously:

I checked the behavior against psql, and psql definitely allows \prompt to work in non-interactive terminals. Although this seems counter-intuitive to me, usql endeavors to be compatible with psql -- as such, I will fix this behavior.

However, the issue is that the readline package usql is using makes it difficult to set / enable this on scripts, due to the way the various packages/components for usql relate to each other. I will make it a point to have this fixed in the next major release, which should also bring in many more compatibility fixes with psql, such as proper formatting, pipe, pager, and other support.

[jgoux]

Hello,

I'm trying usql as a non interactive tool for sql extraction.

Is this issue solved?

I tried running my sql file along with the --set option but my variable isn't replaced :
usql --file test.sql --set=foo=bar --csv oracle://stuff

where test.sql is :

SELECT ':foo' FROM dual;

The output is simply ":foo".

EDIT : Nevermind, my syntax was wrong, :'foo' works great! 👍