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
# JSON data can also be passed as a path to a .json file
oint postgres DeleteTableColumn \
--table "testtable" \
--name "new_field" \
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/" \
--tls "{'use_tls':true,'accept_invalid_certs':true}"
:: JSON data can also be passed as a path to a .json file
oint postgres DeleteTableColumn ^
--table "testtable" ^
--name "new_field" ^
--dbc "postgresql://bayselonarrend:***@127.0.0.1:5432/" ^
--tls "{'use_tls':true,'accept_invalid_certs':true}"
Result
{
"result": true
}