configurations

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

Overview

Name	configurations
Type	Resource
Id	azure.postgresql.configurations

Fields

vw_configurations

Name	Datatype	Description
description	text	field from the properties object
allowed_values	text	field from the properties object
configurationName	text	field from the properties object
data_type	text	field from the properties object
default_value	text	field from the properties object
documentation_link	text	field from the properties object
is_config_pending_restart	text	field from the properties object
is_dynamic_config	text	field from the properties object
is_read_only	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
source	text	field from the properties object
subscriptionId	text	field from the properties object
unit	text	field from the properties object
value	text	field from the properties object

configurations

Name	Datatype	Description
properties	object	The properties of a configuration.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	configurationName, resourceGroupName, serverName, subscriptionId	Gets information about a configuration of server.
list_by_server	SELECT	resourceGroupName, serverName, subscriptionId	List all the configurations in a given server.
update	UPDATE	configurationName, resourceGroupName, serverName, subscriptionId	Updates a configuration of a server.
put	REPLACE	configurationName, resourceGroupName, serverName, subscriptionId	Updates a configuration of a server.

SELECT examples

List all the configurations in a given server.

vw_configurations

SELECT
description,
allowed_values,
configurationName,
data_type,
default_value,
documentation_link,
is_config_pending_restart,
is_dynamic_config,
is_read_only,
resourceGroupName,
serverName,
source,
subscriptionId,
unit,
value
FROM azure.postgresql.vw_configurations
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

configurations

SELECT
properties
FROM azure.postgresql.configurations
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a configurations resource.

/*+ update */
UPDATE azure.postgresql.configurations
SET 
properties = '{{ properties }}'
WHERE 
configurationName = '{{ configurationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

REPLACE example

Replaces all fields in the specified configurations resource.

/*+ update */
REPLACE azure.postgresql.configurations
SET 
properties = '{{ properties }}'
WHERE 
configurationName = '{{ configurationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';