psql
PostgreSQL's interactive command-line client for running SQL statements.
In more detail
The -U flag picks the user and -c runs one statement and exits. Without -c it opens an interactive prompt.
Example
docker exec m06l01-db psql -U postgres -c "SELECT count(*) FROM orders"Related terms
- PostgreSQL — A widely used open source relational database server with strict typing, rich data types and extensions.
- SQL — The standard language for defining, querying and changing data in a relational database.
Taught in
- Dual Writes And Why They Lose Data — Apache Kafka & Event Streaming
- The Transactional Outbox — Apache Kafka & Event Streaming
- Change Data Capture In Principle — Apache Kafka & Event Streaming