SQL Commands - Revision history

Tacoball: /* PostgreSQL */

2026-10-20T09:00:12Z

PostgreSQL

← Older revision		Revision as of 09:00, 20 October 2026
Line 6:		Line 6:
	\| Connection test<br>(host) \|\|		\| Connection test<br>(host) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
			PGPASSWORD='****' psql -U user -h localhost -p 15432 -d dbname -c 'SELECT 1'
	PGPASSWORD='****' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'		PGPASSWORD='****' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'
	~~PGPASSWORD='****' psql -U user -h localhost -p 15432 -d dbname -c 'SELECT 1'~~
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2026-10-20T08:59:56Z

PostgreSQL

← Older revision		Revision as of 08:59, 20 October 2026
Line 6:		Line 6:
	\| Connection test<br>(host) \|\|		\| Connection test<br>(host) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	PGPASSWORD='~~**~~**' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'		PGPASSWORD='****' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'
	PGPASSWORD='~~**~~**' psql -U user -h localhost -p 15432 -d dbname -c 'SELECT 1'		PGPASSWORD='****' psql -U user -h localhost -p 15432 -d dbname -c 'SELECT 1'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-
	\| Connection test<br>(container) \|\|		\| Connection test<br>(container) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	psql ~~postgres://~~user~~@localhost:5432/~~dbname~~?sslmode=require~~ -c 'SELECT 1'		sudo docker exec -e PGPASSWORD='****' -it postgis-ssl psql -U user -d dbname -c 'SELECT 1'
	</syntaxhighlight>		</syntaxhighlight>
	\|}		\|}

2026-10-20T08:56:26Z

PostgreSQL

← Older revision		Revision as of 08:56, 20 October 2026
Line 6:		Line 6:
	\| Connection test<br>(host) \|\|		\| Connection test<br>(host) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	PGPASSWORD='~~1234~~' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'		PGPASSWORD='********' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'
	PGPASSWORD='~~1234~~' psql -U user -h localhost -p 15432 -d dbname -c 'SELECT 1'		PGPASSWORD='********' psql -U user -h localhost -p 15432 -d dbname -c 'SELECT 1'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2026-10-20T08:56:04Z

PostgreSQL

← Older revision		Revision as of 08:56, 20 October 2026
Line 4:		Line 4:
	! 🎯 Purpose \|\| ⌨️ Command		! 🎯 Purpose \|\| ⌨️ Command
	\|-		\|-
	\| Connection test<br>(~~automatic~~) \|\|		\| Connection test<br>(host) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	PGPASSWORD='1234' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'		PGPASSWORD='1234' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'

2026-10-20T08:55:29Z

PostgreSQL

← Older revision		Revision as of 08:55, 20 October 2026
Line 3:		Line 3:
	{\| class="wikitable"		{\| class="wikitable"
	! 🎯 Purpose \|\| ⌨️ Command		! 🎯 Purpose \|\| ⌨️ Command
	\|-
	~~\| Connection test<br>(interactive) \|\|~~
	~~<syntaxhighlight lang="bash">~~
	~~psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'~~
	~~</syntaxhighlight>~~
	\|-		\|-
	\| Connection test<br>(automatic) \|\|		\| Connection test<br>(automatic) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	PGPASSWORD='1234' psql postgres://user@localhost:~~5432~~/dbname?sslmode=require -c 'SELECT 1'		PGPASSWORD='1234' psql postgres://user@localhost:15432/dbname?sslmode=require -c 'SELECT 1'
			PGPASSWORD='1234' psql -U user -h localhost -p 15432 -d dbname -c 'SELECT 1'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2026-10-20T08:52:20Z

PostgreSQL

← Older revision		Revision as of 08:52, 20 October 2026
Line 4:		Line 4:
	! 🎯 Purpose \|\| ⌨️ Command		! 🎯 Purpose \|\| ⌨️ Command
	\|-		\|-
	\| Connection test (interactive) \|\|		\| Connection test<br>(interactive) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'		psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-
	\| Connection test (automatic) \|\|		\| Connection test<br>(automatic) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	PGPASSWORD='1234' psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'		PGPASSWORD='1234' psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-
	\| Connection test (container) \|\|		\| Connection test<br>(container) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'		psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'

2026-10-20T08:51:55Z

PostgreSQL

← Older revision		Revision as of 08:51, 20 October 2026
Line 4:		Line 4:
	! 🎯 Purpose \|\| ⌨️ Command		! 🎯 Purpose \|\| ⌨️ Command
	\|-		\|-
	\| Connection test \|\|		\| Connection test (interactive) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'		psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'
			</syntaxhighlight>
			\|-
			\| Connection test (automatic) \|\|
			<syntaxhighlight lang="bash">
			PGPASSWORD='1234' psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'
	</syntaxhighlight>		</syntaxhighlight>
	\|-		\|-

2026-10-20T08:46:11Z

PostgreSQL

← Older revision		Revision as of 08:46, 20 October 2026
Line 5:		Line 5:
	\|-		\|-
	\| Connection test \|\|		\| Connection test \|\|
			<syntaxhighlight lang="bash">
			psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'
			</syntaxhighlight>
			\|-
			\| Connection test (container) \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'		psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'

2026-10-20T08:42:42Z

PostgreSQL

2026-10-20T08:42:13Z

← Older revision		Revision as of 08:42, 20 October 2026
Line 1:		Line 1:
	== PostgreSQL ==		== PostgreSQL ==

			{\| class="wikitable"
			! \|\|
			\|-
			\| Connection test \|\|
	<syntaxhighlight lang="bash">		<syntaxhighlight lang="bash">
	psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'		psql postgres://user@localhost:5432/dbname?sslmode=require -c 'SELECT 1'
	</syntaxhighlight>		</syntaxhighlight>
			\|}

	== Common Operations ==		== Common Operations ==