Get-AzPostgreSqlFlexibleServerDatabase
Gets information about a database.
Syntax
Get-AzPostgreSqlFlexibleServerDatabase
-ResourceGroupName <String>
-ServerName <String>
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Get-AzPostgreSqlFlexibleServerDatabase
-Name <String>
-ResourceGroupName <String>
-ServerName <String>
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Get-AzPostgreSqlFlexibleServerDatabase
-InputObject <IPostgreSqlIdentity>
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Description
Gets information about a database.
Examples
Example 1: Get databases of a PostgreSql server
Get-AzPostgreSqlFlexibleServerDatabase -ResourceGroupName PowershellPostgreSqlTest -ServerName postgresql-test
Name Charset Collation
---- ------- ---------
azure_maintenance UTF8 en_US.utf8
postgres UTF8 en_US.utf8
azure_sys UTF8 en_US.utf8
flexibleserverdb UTF8 en_US.utf8
Get databases of a flexible server
Example 2: Get a database of a PostgreSql server
Get-AzPostgreSqlFlexibleServerDatabase -ResourceGroupName PowershellPostgreSqlTest -ServerName postgresql-test -Name flexibleserverdb
Name Charset Collation
---- ------- ---------
flexibleserverdb UTF8 en_US.utf8
Get a database of a flexible server by name
Example 3: Get a database of a PostgreSql server
Get-AzPostgreSqlFlexibleServerDatabase -InputObject /subscriptions/0000000000-0000-0000-0000-000000000000/resourceGroups/PowershellPostgreSqlTest/providers/Microsoft.DBforPostgreSQL/flexibleServers/postgresql-test/databases/flexibleserverdb
Name Charset Collation
---- ------- ---------
flexibleserverdb UTF8 en_US.utf8
Get a database of a flexible server by resource Id
Parameters
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
Type: | PSObject |
Aliases: | AzureRMContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InputObject
Identity Parameter To construct, see NOTES section for INPUTOBJECT properties and create a hash table.
Type: | IPostgreSqlIdentity |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-Name
The name of the database.
Type: | String |
Aliases: | DatabaseName |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
The name of the resource group. The name is case insensitive.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ServerName
The name of the server.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-SubscriptionId
The ID of the target subscription.
Type: | String[] |
Position: | Named |
Default value: | (Get-AzContext).Subscription.Id |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Inputs
Outputs
Notes
ALIASES
COMPLEX PARAMETER PROPERTIES
To create the parameters described below, construct a hash table containing the appropriate properties. For information on hash tables, run Get-Help about_Hash_Tables.
INPUTOBJECT <IPostgreSqlIdentity>
: Identity Parameter
[ConfigurationName <String>]
: The name of the server configuration.[DatabaseName <String>]
: The name of the database.[FirewallRuleName <String>]
: The name of the server firewall rule.[Id <String>]
: Resource identity path[LocationName <String>]
: The name of the location.[ResourceGroupName <String>]
: The name of the resource group. The name is case insensitive.[SecurityAlertPolicyName <SecurityAlertPolicyName?>]
: The name of the security alert policy.[ServerName <String>]
: The name of the server.[SubscriptionId <String>]
: The ID of the target subscription.[VirtualNetworkRuleName <String>]
: The name of the virtual network rule.
Azure PowerShell
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for