make_database_address

pyhelpers.dbms.make_database_address(host, port, username, database_name='')

Make a string of a database address.

Parameters

• host (str) – host name/address of a PostgreSQL server

• port (int or str) – listening port used by PostgreSQL

• username (str) – username of a PostgreSQL server

• database_name (str or None) – name of a database, defaults to ""

Returns

address of a database

Return type

str

Examples:

>>> from pyhelpers.dbms import make_database_address

>>> db_addr = make_database_address('localhost', 5432, 'postgres', 'postgres')
>>> db_addr
'postgres:***@localhost:5432/postgres'