postgresql-psql

Name: postgresql-psql
Author: einverne

Comprehensive guide for PostgreSQL psql - the interactive terminal client for PostgreSQL. Use when connecting to PostgreSQL databases, executing queries, managing databases/tables, configuring connection options, formatting output, writing scripts, managing transactions, and using advanced psql features for database administration and development.

TL;DR

Interactive SQL client for PostgreSQL with rich command-line features for database management and scripting.

What Is It

Interactive terminal for PostgreSQL databases
Supports SQL execution and scripting
Provides meta-commands for database navigation and inspection

Key Features

REPL model with command history and editing
Meta-commands for object listing and inspection
Flexible connection options including connection strings and SSH tunneling
SSL/TLS support with multiple modes
Support for environment variables and .pgpass file
Transaction and permission management
Output formatting and export options

How to Use

1.Connect using psql with connection string or environment variables
2.Use meta-commands like \dt or \l to list objects or databases
3.Switch databases with \c or \connect
4.Format output with \a, \H, or \pset
5.Manage transactions and permissions via psql commands

Guardrails & Gotchas

Use .pgpass with chmod 600 to secure credentials
Avoid hardcoding passwords in connection strings
Ensure SSL modes match environment requirements
Never expose sensitive data in connection commands

GitHub Stats

Author

@einverne

Repository

einverne/dotfiles

Stars

119

Explore More Skills

revenuecat

@rawveg

Comprehensive assistance with RevenueCat in-app subscriptions and purchases

687

7mo ago

postgresql-psql

Explore More Skills

revenuecat

api-design-principles

solana-security