Skip to main content

Create database

Creates a database with the specified name

Function CreateDatabase(Val Base, Val Connection = "", Val Tls = "") Export

ParameterCLI optionTypeRequiredDescription
Base--baseStringDatabase name
Connection--dbcString, ArbitraryConnection or connection string
Tls--tlsStructure Of KeyAndValueTLS settings, if necessary. See GetTlsSettings

Returns: Map Of KeyAndValue - Result of query execution


1C:Enterprise/OneScript code example
    Address  = "127.0.0.1";
Login = "bayselonarrend";
Password = "12we...";
Base = "postgres";

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

Base = "testbase1";

// When using the connection string, a new connection is initialised,
// which will be closed after the function is executed.
// If several operations are performed, it is desirable to use one connection,
// previously created by the CreateConnection function()
Result = OPI_PostgreSQL.CreateDatabase(Base, ConnectionString);
    # JSON data can also be passed as a path to a .json file

oint postgres CreateDatabase \
--base "testbase1" \
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/" \
--tls "{'use_tls':true,'accept_invalid_certs':false}"
Result
{
"result": true
}