Comments (5)
That's odd. You're saying that desc ME_13F
works but .schema ME_13F
doesn't work?
from litecli.
yes, only PRAGMA table_info([ME_13F])
works as expected.
i do not need table DDL when i do desc, i need column list
from litecli.
Good point. I'll change desc
and describe
to show what pragma
does.
from litecli.
Amjith has fixed this in #67, please update your litecli to the latest version.
from litecli.
This is still an issue in version 1.2:
litecli Configuration/configuration.db
Version: 1.2.0
Mail: https://groups.google.com/forum/#!forum/litecli-users
GitHub: https://github.com/dbcli/litecli
Configuration/configuration.db> .schema `SemanticIRI`
Time: 0.001s
Configuration/configuration.db>
Compared to vanilla sqlite:
sqlite3 Configuration/configuration.db
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
sqlite> .schema SemanticIRI
CREATE TABLE SemanticIRI (Id INTEGER PRIMARY KEY, IRI TEXT UNIQUE, ObjectInstanceId INTEGER);
CREATE UNIQUE INDEX SemanticIRIIndex ON SemanticIRI(IRI);
from litecli.
Related Issues (20)
- use \033 in prompt HOT 5
- Add support for the `--wrap` and `--wordwrap` options from sqlite3
- Feature request for `.indexes` command support. HOT 2
- No such function: REGEXP
- Support `.eqp` like in sqlite3 HOT 3
- Can't use .once more than once. HOT 1
- When using .once -o, only last line remains HOT 2
- .schema: line breaks and missing index information
- “python_requires” should be set with “>=3.6”, as litecli 1.9.0 is not compatible with all Python versions
- feature request: sqlite3.38+ support for json to use its new features HOT 1
- Test failure with sqlparse==0.4.3
- Header names vague or hidden in grid mode HOT 2
- when insert to `table t(t text)` , raise an exception
- When long wide characters are stored in the database, it will not output some rows if enabled auto_vertical_output HOT 1
- STRICT tables seem to not be supported HOT 1
- FR: configuration to import custom python functions
- Feature comparison with SQLite CLI special commands (dot commands) HOT 1
- FR: support environment variables in (favourite) queries
- Cancelling a query leads to an error message, there is no 'KILL' command in sqlite HOT 1
- syntax style changes output behaviour HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from litecli.