textql icon indicating copy to clipboard operation
textql copied to clipboard

Document `stdin` table name for piped input

Open abathur opened this issue 6 years ago • 3 comments

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.

abathur avatar Mar 17 '18 16:03 abathur

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

SaymV avatar Dec 06 '18 16:12 SaymV

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

geekscrapy avatar Dec 17 '19 10:12 geekscrapy

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

gabrielf avatar Mar 11 '20 14:03 gabrielf