Skip to main content

Delete table column

Deletes a column from the table

Function DeleteTableColumn(Val Table, Val Name, Val Connection = "", Val Tls = "") Export

ParameterCLI optionTypeRequiredDescription
Table--tableStringTable name
Name--nameStringColumn 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 = "testbase1";

TLS = True;
Port = 5432;
ConnectionString = OPI_PostgreSQL.GenerateConnectionString(Address, Base, Login, Password, Port);

If TLS Then
TLSSettings = OPI_PostgreSQL.GetTLSSettings(True);
Else
TLSSettings = Undefined;
EndIf;

Table = "testtable";
Name = "new_field";

Result = OPI_PostgreSQL.DeleteTableColumn(Table, Name, ConnectionString, TLSSettings);
    oint postgres DeleteTableColumn \
--table ""testtable"" \
--name ""new_field"" \
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/" \
--tls ""/tmp/zbh3klk5.2gd.json""
Result
{
"result": true
}