Share via

Microsoft.DBforPostgreSQL servers/databases 2017-12-01

  • Article

Bicep resource definition

The servers/databases resource type can be deployed with operations that target:

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforPostgreSQL/servers/databases resource, add the following Bicep to your template.

resource symbolicname 'Microsoft.DBforPostgreSQL/servers/databases@2017-12-01' = {
  parent: resourceSymbolicName
  name: 'string'
  properties: {
    charset: 'string'
    collation: 'string'
  }
}

Property values

DatabaseProperties

Name Description Value
charset The charset of the database. string
collation The collation of the database. string

Microsoft.DBforPostgreSQL/servers/databases

Name Description Value
name The resource name string (required)
parent In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource.

For more information, see Child resource outside parent resource.		 Symbolic name for resource of type: servers
properties The properties of a database. DatabaseProperties

Quickstart samples

The following quickstart samples deploy this resource type.

Bicep File Description
Sonarqube Docker Web App on Linux with PostgreSQL This template provides a easy way to deploy a Sonarqube docker image (alpine tag) on a Linux Web App with Azure database for PostgreSQL(Preview)

ARM template resource definition

The servers/databases resource type can be deployed with operations that target:

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforPostgreSQL/servers/databases resource, add the following JSON to your template.

{
  "type": "Microsoft.DBforPostgreSQL/servers/databases",
  "apiVersion": "2017-12-01",
  "name": "string",
  "properties": {
    "charset": "string",
    "collation": "string"
  }
}

Property values

DatabaseProperties

Name Description Value
charset The charset of the database. string
collation The collation of the database. string

Microsoft.DBforPostgreSQL/servers/databases

Name Description Value
apiVersion The api version '2017-12-01'
name The resource name string (required)
properties The properties of a database. DatabaseProperties
type The resource type 'Microsoft.DBforPostgreSQL/servers/databases'

Quickstart templates

The following quickstart templates deploy this resource type.

Template Description
Sonarqube Docker Web App on Linux with PostgreSQL

Deploy to Azure		 This template provides a easy way to deploy a Sonarqube docker image (alpine tag) on a Linux Web App with Azure database for PostgreSQL(Preview)

Terraform (AzAPI provider) resource definition

The servers/databases resource type can be deployed with operations that target:

  • Resource groups

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforPostgreSQL/servers/databases resource, add the following Terraform to your template.

resource "azapi_resource" "symbolicname" {
  type = "Microsoft.DBforPostgreSQL/servers/databases@2017-12-01"
  name = "string"
  body = jsonencode({
    properties = {
      charset = "string"
      collation = "string"
    }
  })
}

Property values

DatabaseProperties

Name Description Value
charset The charset of the database. string
collation The collation of the database. string

Microsoft.DBforPostgreSQL/servers/databases

Name Description Value
name The resource name string (required)
parent_id The ID of the resource that is the parent for this resource. ID for resource of type: servers
properties The properties of a database. DatabaseProperties
type The resource type "Microsoft.DBforPostgreSQL/servers/databases@2017-12-01"