Postgresql: Difference between revisions

From Halfface
Jump to navigation Jump to search
(Created page with "=connect=")
 
Line 1: Line 1:
=connect=
=psql=
Connect to remote database:
export PGPASSWORD=password && psql --host=10.111.222.1 --port=5492 --username=user --no-password postgres
=List databases=
SELECT datname FROM pg_database;

Revision as of 12:29, 18 December 2018

psql

Connect to remote database:

export PGPASSWORD=password && psql --host=10.111.222.1 --port=5492 --username=user --no-password postgres

List databases

SELECT datname FROM pg_database;