PostgreSQL Connecting to a Database: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 18: Line 18:


Specifies the port.
Specifies the port.
==-c, --command==
Run only single command (SQL or internal) and exit.


=Examples=
=Examples=

Revision as of 21:09, 2 October 2019

Internal

Connect

Connect to a database.

Options

-h|--host=

-U|--username=

-d|--dbname=

Specifies the name of the database to connect to.

-p

Specifies the port.

-c, --command

Run only single command (SQL or internal) and exit.

Examples

Connect Locally to the Default Database

psql postgres

This should work without any additional configuration.

Connect to a Remote Database

psql -h <host-name> -U <username> -d <database-name>
psql -h dev01.example.us-west-2.rds.amazonaws.com -U root -d dev01

If the database name is not specified, will connect to ...

Connect to the Default Database

psql -h localhost -U admin

Connect as a Specific User to a Database

psql -U <username> <dbname>

Connect to a PostgreSQL Instance Running in a Kubernetes Pod that Has Been Exposed as a NodePort Service

psql -h localhost -p 5432 -U postgres