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
 - CMD/Bat
 
    oint postgres GenerateConnectionString \
     --addr "127.0.0.1" \
     --db "postgres" \
     --login "bayselonarrend" \
     --pass "***" \
     --port 5433
    oint postgres GenerateConnectionString ^
     --addr "127.0.0.1" ^
     --db "postgres" ^
     --login "bayselonarrend" ^
     --pass "***" ^
     --port 5433
Result
"postgresql://bayselonarrend:***@127.0.0.1:5432/postgres"