Skip to main content

operations

Creates, updates, deletes, gets or lists an operations resource.

Overview

Nameoperations
TypeResource
Idazure.postgresql.operations

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringThe name of the operation being performed on this particular object.
displayobjectThe localized display information for this particular operation or action.
isDataActionbooleanIndicates whether the operation is a data action
originstringThe intended executor of the operation.
propertiesobjectAdditional descriptions for the operation.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectLists all of the available REST API operations.
check_migration_name_availabilityexecsubscriptionId, resourceGroupName, targetDbServerName, name, typeThis method checks whether a proposed migration name is valid and available.
check_name_availability_executeexecsubscriptionIdCheck the availability of name for resource
check_name_availability_with_location_executeexecsubscriptionId, locationNameCheck the availability of name for resource

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
locationNamestringThe name of the location.
resourceGroupNamestringThe resource group name of the target database server.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
targetDbServerNamestringThe name of the target database server.

SELECT examples

Lists all of the available REST API operations.

SELECT
name,
display,
isDataAction,
origin,
properties
FROM azure.postgresql.operations
;

Lifecycle Methods

This method checks whether a proposed migration name is valid and available.

EXEC azure.postgresql.operations.check_migration_name_availability 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@targetDbServerName='{{ targetDbServerName }}' --required
@@json=
'{
"name": "{{ name }}",
"type": "{{ type }}"
}'
;