Cheat Sheet logoCheat Sheet Today
psql Cheat Sheet/Show current connection

Display current host, port, user, and database connection info.

Back to sheetBrowse commands
Sign in to save
Section: Connecting and Session Variables

Show current connection

sql
sql
\conninfo
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Connecting and Session Variables
Connect with host port user and database
Connect with explicit connection flags.
OpenIn sheetbashsame section
Never prompt for password
Fail instead of prompting for a password.
OpenIn sheetbashsame section
Force password prompt
Always prompt for the password interactively.
OpenIn sheetbashsame section
Set psql variable
Create or update a psql variable.
OpenIn sheetsqlsame section
Use psql variable in SQL
Interpolate a psql variable in a command.
OpenIn sheetsqlsame section
Use PGPASSFILE
Use a password file for noninteractive authentication.
OpenIn sheetbashsame section