PostgreSQL Cheat Sheet - Revision history

MkWikiEnSysOp: Added man page of psql

2025-05-30T10:12:50Z

Added man page of psql

← Older revision		Revision as of 10:12, 30 May 2025
Line 1:		Line 1:
			[https://linux.die.net/man/1/psql psql manual page]

	== Open SQL Shell ==		== Open SQL Shell ==

MkWikiEnSysOp: /* Open SQL Shell */

2025-05-30T10:11:35Z

Open SQL Shell

← Older revision		Revision as of 10:11, 30 May 2025
Line 1:		Line 1:
	== Open SQL Shell ==		== Open SQL Shell ==

			=== As user "postgres" ===

	sudo -u postgres psql		sudo -u postgres psql

			=== As arbitrary user using TCP/IP ===

			psql -h '''host''' -d '''database''' -U '''username''' --password

			Even on localhost it's necessary to specify "-h localhost", otherwise an error will appear unless the server isn't configured to allow this kind of connections:

			psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "user"

	== Important Commands ==		== Important Commands ==

MkWikiEnSysOp: Added category

2025-05-30T10:08:18Z

Added category

← Older revision		Revision as of 10:08, 30 May 2025
Line 20:		Line 20:
	\| \df \|\| '''D'''isplay '''f'''unctions		\| \df \|\| '''D'''isplay '''f'''unctions
	\|}		\|}

			[[Category:PostgreSQL]]

MkWikiEnSysOp: Important Commands

2025-05-29T10:34:31Z

Important Commands

New page

== Open SQL Shell ==

sudo -u postgres psql

== Important Commands ==

{| class="wikitable sortable"
|+ Caption text
|-
! Command !! Description
|-
| \l || '''L'''ist databases
|-
| \c || '''C'''onnect to database
|-
| \dt || '''D'''isplay '''t'''ables
|-
| \dv || '''D'''isplay '''v'''iews
|-
| \df || '''D'''isplay '''f'''unctions
|}