SQLite Forum

Sending output to a pipe
Login
It is still very useful in scripts:

```sh
sqlite3 -bail test.sqlite <<EOSQL
CREATE TABLE a (
  id  INTEGER PRIMARY KEY NOT NULL
, tx  TEXT
);
INSERT INTO a VALUES (1,'one');
INSERT INTO a VALUES (2,'two');
INSERT INTO a VALUES (3,'three');
.once |less
SELECT * FROM a;
EOSQL
```