Skip to main content

servers

Creates, updates, deletes, gets or lists a servers resource.

Overview

Nameservers
TypeResource
Idazure.postgresql_hsc.servers

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
propertiesobjectThe properties of a server in a cluster.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, clusterName, serverNameGets information about a server in cluster.
list_by_clusterselectsubscriptionId, resourceGroupName, clusterNameLists servers of a cluster.

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
clusterNamestringThe name of the cluster.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
serverNamestringThe name of the server.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Gets information about a server in cluster.

SELECT
properties
FROM azure.postgresql_hsc.servers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND clusterName = '{{ clusterName }}' -- required
AND serverName = '{{ serverName }}' -- required
;