Connect to PostgreSQL

From wikieduonline
(Redirected from Connect to remote database)
Jump to navigation Jump to search


  • createdb your-db && psql your-db


  • psql --host=mypostgresql.c6c8mwvfdgv0.us-west-2.rds.amazonaws.com --port=5432 --username=awsuser --password --dbname=mypgdb

Related[edit]


PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, \conninfo, --version, --help, PL/pgSQL

Retrieved from "https://www.wikieduonline.com/index.php?title=Connect_to_PostgreSQL&oldid=359650"

Advertising: