Resource Type: Azure > PostgreSQL

The PostgreSQL service offers scalable database capacity in the Azure cloud. It enables users to initiate and manage virtual databases, known as instances, that can run applications and services.

Resource Types

The PostgreSQL service includes these resource types:

In Your Workspace

Developers

Resource Type URI

tmod:@turbot/azure-postgresql#/resource/types/postgreSql

Category URI

tmod:@turbot/turbot#/resource/categories/cloudService

GraphQL

query resource(id: "tmod:@turbot/azure-postgresql#/resource/types/postgreSql") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/azure-postgresql#/resource/types/postgreSql'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/azure-postgresql#/resource/types/postgreSql"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/azure-postgresql#/resource/types/postgreSql';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/azure-postgresql#/resource/types/postgreSql"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/azure-postgresql#/resource/types/postgreSql' and notification_type in ('resource_updated', 'resource_created');