SQLite3 not working on Powershell

Question

I'm a relative novice when it comes to code, so if I'm missing the obvious please excuse me; my issue is getting SQLite3 (version 3.7.15.2 to be exact) to work in Powershell. I installed SQLite3 on my computer and the SQLite3 shell works fine on its own, but when I attempt to use SQLite3 via Powershell I get error messages.

If I just type in the sqlite3 in Powershell it states that it is not a recognized command; however, when I attempt to run a basic SQL script via the following commands in Powershell I get this error message instead:

sqlite3 ex1.db < ex1.sql

error message: "The '<' operator is reserved for future use

With all of this being said, what could be the issue?

Thanks for your time!

Answer 1

"<" (stdin) redirection is not supported in Powershell.

Perhaps you can try to put your cammands in a file sqlcmd.txt and try :

Get-Content sqlcmd.txt | sqlite3.exe > output.txt

Be careful to use the full path for your exe if it's not into the PATH.