Skip to main content

Drop database

Deletes the database

Function DeleteDatabase(Val Base, Val Connection = "") Export

ParameterCLI optionTypeRequiredDescription
Base--baseStringDatabase name
Connection--dbcString, ArbitraryConnection or connection string

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.DeleteDatabase(Base, ConnectionString);
    oint postgres DeleteDatabase \
--base "testbase1" \
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/"
Result
{
"result": true
}