Delete table column
Deletes a column from the table
Function DeleteTableColumn(Val Table, Val Name, Val Connection = "", Val Tls = "") Export
Parameter | CLI option | Type | Required | Description |
---|---|---|---|---|
Table | --table | String | ✔ | Table name |
Name | --name | String | ✔ | Column name |
Connection | --dbc | String, Arbitrary | ✖ | Connection or connection string |
Tls | --tls | Structure Of KeyAndValue | ✖ | TLS 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);
- Bash
- CMD/Bat
oint postgres DeleteTableColumn \
--table ""testtable"" \
--name ""new_field"" \
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/" \
--tls ""/tmp/zbh3klk5.2gd.json""
oint postgres DeleteTableColumn ^
--table ""testtable"" ^
--name ""new_field"" ^
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/" ^
--tls ""/tmp/zbh3klk5.2gd.json""
Result
{
"result": true
}