postgresql-psql

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

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

• 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

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