psql and First Commands
Part of the PostgreSQL course
You now know what Postgres is for. The next problem is more practical: how do you actually talk to it? A running Postgres server just sits there listening on a network port, it has no windows, no buttons, nothing to click. Graphical database tools exist, but they are one more thing to install, they are not always available on a server you only reach over SSH, and every one of them is, under the hood, just sending...
Your workspace already has a Postgres server running and a superuser account called postgres. Open a terminal and connect to it ...
Want to learn PostgreSQL psql and First Commands in a real environment?
Click below, get a fresh Linux box with PostgreSQL ready to go, and work through psql and First Commands hands-on with an AI tutor that knows your code.
Start this lessonpsql and First CommandsWhat you'll learn
- Psql command line client
- Connecting as postgres user
- Meta commands like \l \c \dt \d \q
- Semicolons end statements
- Multiline queries
- SELECT version()
Read this lesson in your language
All lessons in this course
14 lessons- 1What is PostgreSQL20 min
- 2psql and First Commands25 min
- 3Creating Databases and Tables30 min
- 4Data Types25 min
- 5SELECT and WHERE30 min
- 6Joins35 min
- 7Aggregates and Grouping30 min
- 8Indexes35 min
- 9Transactions and Isolation35 min
- 10Functions and Triggers35 min
- 11JSONB and Arrays35 min
- 12EXPLAIN and Query Tuning35 min
- 13Backup and Restore25 min
- 14Capstone: Design a Schema60 min
