What is the format for the PostgreSQL connection string / URL?

by

If you use Libpq binding for respective language, according to its documentation URI is formed as follows:

postgresql://[user[:password]@][netloc][:port][/dbname][?param1=value1&...]

Here are examples from same document

postgresql://
postgresql://localhost
postgresql://localhost:5432
postgresql://localhost/mydb
postgresql://user@localhost
postgresql://user:secret@localhost
postgresql://other@localhost/otherdb?connect_timeout=10&application_name=myapp
postgresql://localhost/mydb?user=other&password=secret

More Related Contents:

  1. Is there a timeout for idle PostgreSQL connections?
  2. How do I change a Crystal Report’s ODBC database connection at runtime?
  3. What is PostgreSQL equivalent to autoincrement?
  4. How do I specify a password to ‘psql’ non-interactively?
  5. INSERT with dynamic table name in trigger function
  6. psql: FATAL: Ident authentication failed for user “postgres”
  7. Use multiple conflict_target in ON CONFLICT clause
  8. Python Postgres psycopg2 ThreadedConnectionPool exhausted
  9. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  10. How to find table creation time?
  11. Creating a copy of a database in PostgreSQL
  12. PostgreSQL function returning multiple result sets
  13. How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?
  14. Can’t connect the postgreSQL with psycopg2
  15. How do you change the character encoding of a postgres database?
  16. Difference between GiST and GIN index
  17. Test for null in function with varying parameters
  18. PostgreSQL: Why psql can’t connect to server?
  19. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  20. Can I use return value of INSERT…RETURNING in another INSERT?
  21. Changing a postgres containers server port in Docker Compose
  22. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  23. no pg_hba.conf entry for host
  24. PostgreSQL – disabling constraints
  25. PostgreSQL authentication method 10 not supported
  26. PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values
  27. input file appears to be a text format dump. Please use psql
  28. Spring Docker container cannot access Postgres Docker container
  29. Format specifier for integer variables in format() for EXECUTE?
  30. PostgreSQL composite primary key

Leave a Comment