EasyEnv
Engineering/Courses/Catalog/PostgreSQL/psql and First Commands
PostgreSQL
IntermediateLesson 2 of 1425 min · hands-on

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 Commands

What 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
  1. 1What is PostgreSQL20 min
  2. 2psql and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types25 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes35 min
  9. 9Transactions and Isolation35 min
  10. 10Functions and Triggers35 min
  11. 11JSONB and Arrays35 min
  12. 12EXPLAIN and Query Tuning35 min
  13. 13Backup and Restore25 min
  14. 14Capstone: Design a Schema60 min

Explore other courses

psql and First Commands - PostgreSQL (English) | Engineering Courses