Generate connection string

Forms a connection string from the passed data

Function GenerateConnectionString(Val Address, Val Base, Val Login, Val Password = "", Val Port = "5432") Export

Parameter	CLI option	Type	Required	Description
Address	--addr	String	✔	IP address or domain name of the server
Base	--db	String	✔	Name of the database to connect
Login	--login	String	✔	Postgres user login
Password	--pass	String	✖	Postgres user password
Port	--port	String	✖	Connection port

Returns: String - PostgreSQL database connection string

1C:Enterprise/OneScript code example

    Address  = "127.0.0.1";
    Login    = "bayselonarrend";
    Password = "12we...";
    Base     = "postgres";

    Result = OPI_PostgreSQL.GenerateConnectionString(Address, Base, Login, Password);

Bash

    oint postgres GenerateConnectionString \
     --addr "127.0.0.1" \
     --db "postgres" \
     --login "bayselonarrend" \
     --pass "***"

CMD/Bat

    oint postgres GenerateConnectionString ^
     --addr "127.0.0.1" ^
     --db "postgres" ^
     --login "bayselonarrend" ^
     --pass "***"

Result

"postgresql://bayselonarrend:***@127.0.0.1:5432/postgres"