Essential PostgreSQL Shortcut Commands for Efficient Database Management
📌 Master psql with these quick and powerful shortcut commands!
Category: Database, PostgreSQL
Tags: PostgreSQL, psql, database management, SQL commands
Slug: postgresql-shortcut-commands
📖 Introduction
PostgreSQL provides a powerful command-line tool called psql that allows you to interact with and manage your databases efficiently. If you’re a developer, database administrator, or someone working with SQL databases, these shortcuts will save you time and effort.
💡 In this guide, you’ll find:
✅ Quick commands for database management
✅ Shortcuts for schemas, objects, and roles
✅ Handy tools for query formatting and output control
🔹 General Shortcuts 🏁
Basic commands to navigate psql quickly:
| Command | Description |
|---|---|
| \? | Show all available psql commands |
| \q | Exit the psql client |
| \c [dbname] | Connect to a specific database |
| \conninfo | Show connection details |
| \encoding | Display or change the client character encoding |
| \! [command] | Run a shell command |
| \pwd | Display the current working directory |
🔹 Database Management 📂
Manage your databases efficiently with these commands:
| Command | Description |
|---|---|
| \l | List all databases |
| \l+ | List databases with extra details (size, owner, etc.) |
| \g | Execute the last SQL command again |
| \i [file] | Run SQL commands from a file |
| \watch [interval] | Rerun the last query at specified intervals |
🔹 Schemas & Objects 🏛️
| Command | Description |
|---|---|
| \dn | List all schemas in the current database |
| \dn+ | List schemas with extra details |
| \dt | List all tables in the current schema |
| \dt+ | Show tables with additional details (size, storage) |
| \dv | List all views in the current schema |
| \dv+ | Show views with additional details |
| \ds | List all sequences in the current schema |
| \ds+ | Show sequences with additional details |
| \df | List all functions in the current schema |
| \df+ | Show functions with argument and return type details |
| \db | List all tablespaces |
| \db+ | Show tablespaces with additional details |
🔹 Object Descriptions 🔍
Get details about database objects with these commands:
| Command | Description |
|---|---|
| \d [object] | Describe a specific object (table, view, etc.) |
| \d+ [object] | Show detailed information about an object |
| \d | General object listing in the current schema |
| \z | List access privileges for all objects |
| \dp | Show access privileges for tables, views, and sequences |
🔹 Role & User Management 👥
Manage users and roles in PostgreSQL:
| Command | Description |
|---|---|
| \du | List all roles (users) in the database cluster |
| \du+ | Show roles with additional details |
🔹 Query Output Formatting 🎨
Improve the readability of your SQL query results:
| Command | Description |
|---|---|
| \x | Toggle expanded output mode (vertical format) |
| \o [file] | Redirect query output to a file |
| \o | Reset output redirection back to the terminal |
| \t | Toggle table headings and row counts |
| \a | Switch between aligned and unaligned output formats |
📌 Bonus Tips for Using psql Effectively 💡
✅ Use Autocompletion: Press TAB to auto-complete commands
✅ History Navigation: Use the up and down arrow keys to navigate through previous commands
✅ Execute Multiple Queries: Use a semicolon (;) to separate multiple SQL commands in one execution
🎯 Final Thoughts
These PostgreSQL shortcut commands will help you work more efficiently with databases, whether you’re a beginner or an experienced user.
📌 Bookmark this page or save it for future reference! Have a favorite psql shortcut? 💬 Let us know in the comments below. 🚀
📢 Share This Guide!
If you found this guide helpful, share it with your fellow developers and DBAs!
🔗 Share on Twitter | Share on LinkedIn | Share on Facebook
