1. Packages
  2. OVH
  3. API Docs
  4. CloudProjectDatabase
  5. getPostgresSqlUser
Viewing docs for OVHCloud v2.12.0
published on Thursday, Mar 12, 2026 by OVHcloud
Schema (JSON)
ovh/pulumi-ovh

ovh.CloudProjectDatabase.getPostgresSqlUser

ovh logo
Viewing docs for OVHCloud v2.12.0
published on Thursday, Mar 12, 2026 by OVHcloud
Schema (JSON)
ovh/pulumi-ovh

    Use this data source to get information about a user of a postgresql cluster associated with a public cloud project.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as ovh from "@ovhcloud/pulumi-ovh";

const pgUser = ovh.CloudProjectDatabase.getPostgresSqlUser({
    serviceName: "XXX",
    clusterId: "YYY",
    name: "ZZZ",
});
export const pgUserRoles = pgUser.then(pgUser => pgUser.roles);

    import pulumi
import pulumi_ovh as ovh

pg_user = ovh.CloudProjectDatabase.get_postgres_sql_user(service_name="XXX",
    cluster_id="YYY",
    name="ZZZ")
pulumi.export("pgUserRoles", pg_user.roles)

    package main

import (
	"github.com/ovh/pulumi-ovh/sdk/v2/go/ovh/cloudprojectdatabase"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		pgUser, err := cloudprojectdatabase.GetPostgresSqlUser(ctx, &cloudprojectdatabase.GetPostgresSqlUserArgs{
			ServiceName: "XXX",
			ClusterId:   "YYY",
			Name:        "ZZZ",
		}, nil)
		if err != nil {
			return err
		}
		ctx.Export("pgUserRoles", pgUser.Roles)
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Ovh = Pulumi.Ovh;

return await Deployment.RunAsync(() => 
{
    var pgUser = Ovh.CloudProjectDatabase.GetPostgresSqlUser.Invoke(new()
    {
        ServiceName = "XXX",
        ClusterId = "YYY",
        Name = "ZZZ",
    });

    return new Dictionary<string, object?>
    {
        ["pgUserRoles"] = pgUser.Apply(getPostgresSqlUserResult => getPostgresSqlUserResult.Roles),
    };
});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.ovh.CloudProjectDatabase.CloudProjectDatabaseFunctions;
import com.pulumi.ovh.CloudProjectDatabase.inputs.GetPostgresSqlUserArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var pgUser = CloudProjectDatabaseFunctions.getPostgresSqlUser(GetPostgresSqlUserArgs.builder()
            .serviceName("XXX")
            .clusterId("YYY")
            .name("ZZZ")
            .build());

        ctx.export("pgUserRoles", pgUser.roles());
    }
}

    variables:
  pgUser:
    fn::invoke:
      function: ovh:CloudProjectDatabase:getPostgresSqlUser
      arguments:
        serviceName: XXX
        clusterId: YYY
        name: ZZZ
outputs:
  pgUserRoles: ${pgUser.roles}

    Using getPostgresSqlUser

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getPostgresSqlUser(args: GetPostgresSqlUserArgs, opts?: InvokeOptions): Promise<GetPostgresSqlUserResult>
function getPostgresSqlUserOutput(args: GetPostgresSqlUserOutputArgs, opts?: InvokeOptions): Output<GetPostgresSqlUserResult>
    def get_postgres_sql_user(cluster_id: Optional[str] = None,
                          name: Optional[str] = None,
                          service_name: Optional[str] = None,
                          opts: Optional[InvokeOptions] = None) -> GetPostgresSqlUserResult
def get_postgres_sql_user_output(cluster_id: Optional[pulumi.Input[str]] = None,
                          name: Optional[pulumi.Input[str]] = None,
                          service_name: Optional[pulumi.Input[str]] = None,
                          opts: Optional[InvokeOptions] = None) -> Output[GetPostgresSqlUserResult]
    func LookupPostgresSqlUser(ctx *Context, args *LookupPostgresSqlUserArgs, opts ...InvokeOption) (*LookupPostgresSqlUserResult, error)
func LookupPostgresSqlUserOutput(ctx *Context, args *LookupPostgresSqlUserOutputArgs, opts ...InvokeOption) LookupPostgresSqlUserResultOutput

    > Note: This function is named LookupPostgresSqlUser in the Go SDK.

    public static class GetPostgresSqlUser 
{
    public static Task<GetPostgresSqlUserResult> InvokeAsync(GetPostgresSqlUserArgs args, InvokeOptions? opts = null)
    public static Output<GetPostgresSqlUserResult> Invoke(GetPostgresSqlUserInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetPostgresSqlUserResult> getPostgresSqlUser(GetPostgresSqlUserArgs args, InvokeOptions options)
public static Output<GetPostgresSqlUserResult> getPostgresSqlUser(GetPostgresSqlUserArgs args, InvokeOptions options)

    fn::invoke:
  function: ovh:CloudProjectDatabase/getPostgresSqlUser:getPostgresSqlUser
  arguments:
    # arguments dictionary

    The following arguments are supported:

    ClusterId string
    Cluster ID
    Name string
    Name of the user.
    ServiceName string
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    ClusterId string
    Cluster ID
    Name string
    Name of the user.
    ServiceName string
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    clusterId String
    Cluster ID
    name String
    Name of the user.
    serviceName String
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    clusterId string
    Cluster ID
    name string
    Name of the user.
    serviceName string
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    cluster_id str
    Cluster ID
    name str
    Name of the user.
    service_name str
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.
    clusterId String
    Cluster ID
    name String
    Name of the user.
    serviceName String
    The id of the public cloud project. If omitted, the OVH_CLOUD_PROJECT_SERVICE environment variable is used.

    getPostgresSqlUser Result

    The following output properties are available:

    ClusterId string
    See Argument Reference above.
    CreatedAt string
    Date of the creation of the user.
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    Name of the user.
    Roles List<string>
    Roles the user belongs to.
    ServiceName string
    Current status of the user.
    Status string
    Current status of the user.
    ClusterId string
    See Argument Reference above.
    CreatedAt string
    Date of the creation of the user.
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    Name of the user.
    Roles []string
    Roles the user belongs to.
    ServiceName string
    Current status of the user.
    Status string
    Current status of the user.
    clusterId String
    See Argument Reference above.
    createdAt String
    Date of the creation of the user.
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    Name of the user.
    roles List<String>
    Roles the user belongs to.
    serviceName String
    Current status of the user.
    status String
    Current status of the user.
    clusterId string
    See Argument Reference above.
    createdAt string
    Date of the creation of the user.
    id string
    The provider-assigned unique ID for this managed resource.
    name string
    Name of the user.
    roles string[]
    Roles the user belongs to.
    serviceName string
    Current status of the user.
    status string
    Current status of the user.
    cluster_id str
    See Argument Reference above.
    created_at str
    Date of the creation of the user.
    id str
    The provider-assigned unique ID for this managed resource.
    name str
    Name of the user.
    roles Sequence[str]
    Roles the user belongs to.
    service_name str
    Current status of the user.
    status str
    Current status of the user.
    clusterId String
    See Argument Reference above.
    createdAt String
    Date of the creation of the user.
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    Name of the user.
    roles List<String>
    Roles the user belongs to.
    serviceName String
    Current status of the user.
    status String
    Current status of the user.

    Package Details

    Repository
    ovh ovh/pulumi-ovh
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the ovh Terraform Provider.
    ovh logo
    Viewing docs for OVHCloud v2.12.0
    published on Thursday, Mar 12, 2026 by OVHcloud
    Schema (JSON)
    ovh/pulumi-ovh
      Try Pulumi Cloud free. Your team will thank you.