PostgreSQL client utilities

/ home / computer / postgresql / postgresql-for-mysql-admins / .

Command Line Interfaces (CLI)

• psql (mysql)
• other CLI tools

https://www.postgresql.org/docs/current/app-psql.html

Disconnect / quit \q

List psql commands (via psql) ?

\cd /home/oli/fromdual_devel/myenv/sql/postgresql \set ECHO queries \pset pager 0 \i show_global_variables

show_global_variables.sql show_processlist.sql show_global_status.sql show_databases.sql show_schemas.sql show_tables.sql test_table.sql

TODO: world.sql.gz and Foodmart!

Graphical User Interfaces (GUI)

Fat client GUI

Similar to MySQL Workbench:

• pgAdmin (Web and Fat client), Source, Installation, Access or /usr/pgadmin4/bin/pgadmin4

Web-GUI

Similar to phpMyAdmin:

• [phpPgAdmin], Source 1, Source 2, Installation: apt install phppgadmin, Access - Not clear to me which is the right version???
• Adminer, Source, Installation, Access

Navigation

See also: Navigation.

Connect to the Cluster:

$ psql -U admin -W secret -h 127.0.0.1 -p 5432 foodmart

$ psql --username=admin --password=secret --host=127.0.0.1 --port=5432 foodmart

$ psql --username=admin --password=secret --host=/var/run/postgresql foodmart