search

dinedal / textql

Execute SQL against structured text like CSV or TSV
MIT License
9.05k stars 300 forks source link

Document `stdin` table name for piped input #70

Open abathur opened 6 years ago

abathur commented 6 years ago

Not a huge problem, but I had to spend a little more effort than ideal figuring out to run an update statement against the stdin table for a piped CSV. It would be ideal if this was documented.

Easy enough to answer with a query: blah blah blah | textql -sql "SELECT name FROM sqlite_master WHERE type='table'"

But, of course, I tried the short syntax, pipe, checking the readme, and searching the code thinking it might just be a random string before I thought about just querying.

SaymV commented 5 years ago

A google search landed me here. It would be nice if this was in the documentation directly.

geekscrapy commented 4 years ago

Yes, what are the default tables created for the likes of stdin?

gabrielf commented 4 years ago

The table name for stdin is stdin. Found this out by guessing :-)