man psql + psql meta-commands + shell-like features

• psql PostgreSQL 15.1 Documentation
  • Specifies that psql is to execute the given command string,command
  • Switches to CSV (Comma-Separated Values) output mode
  • Read commands from the file filename
  • Switches to HTML output mode
  • Put all query output into file filename
  • Specifies that psql should do its work quietly
  • the user is prompted before each command is sent to the server
  • Connect to the database as the user username instead of the default
  • single transaction
  • Outputs information about the current database connection
  • Shows the copyright and distribution terms of PostgreSQL
  • Lists server configuration parameters and their values
  • Lists database roles
  • Lists schemas (namespaces)
  • Lists tables, views and sequences with their associated access privileges
  • Lists partitioned relations
  • Lists defined configuration settings
  • Lists database roles