Postgresql: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=connect=") |
|||
| Line 1: | Line 1: | ||
= | =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;