Command-line interfaces such as PostgreSQL's psql and SQLite's sqlite3 let users type SQL commands interactively, providing direct manual access to the database. Graphical tools offer the same capability with a visual front-end, but they are not the only method. Direct access does not require the database to be offline, and CLIs are used for issuing queries as well as for importing data.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a CLI, and how does it provide manual access to a database?
Open an interactive chat with Bash
How do graphical user interfaces (GUIs) compare to CLIs for accessing databases?
Open an interactive chat with Bash
Why is direct manual access to a database useful for database management?