1. Packages
  2. Postgresql Provider
  3. API Docs
  4. getSequences
PostgreSQL v3.16.0 published on Tuesday, Sep 2, 2025 by Pulumi
pulumi/pulumi-postgresql

postgresql.getSequences

Get Started
postgresql logo
PostgreSQL v3.16.0 published on Tuesday, Sep 2, 2025 by Pulumi
pulumi/pulumi-postgresql

    The postgresql.getSequences data source retrieves a list of sequence names from a specified PostgreSQL database.

    Usage

    import * as pulumi from "@pulumi/pulumi";
import * as postgresql from "@pulumi/postgresql";

const mySequences = postgresql.getSequences({
    database: "my_database",
});

    import pulumi
import pulumi_postgresql as postgresql

my_sequences = postgresql.get_sequences(database="my_database")

    package main

import (
	"github.com/pulumi/pulumi-postgresql/sdk/v3/go/postgresql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := postgresql.GetSequences(ctx, &postgresql.GetSequencesArgs{
			Database: "my_database",
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var mySequences = PostgreSql.GetSequences.Invoke(new()
    {
        Database = "my_database",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.postgresql.PostgresqlFunctions;
import com.pulumi.postgresql.inputs.GetSequencesArgs;
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 mySequences = PostgresqlFunctions.getSequences(GetSequencesArgs.builder()
            .database("my_database")
            .build());

    }
}

    variables:
  mySequences:
    fn::invoke:
      function: postgresql:getSequences
      arguments:
        database: my_database

    Using getSequences

    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 getSequences(args: GetSequencesArgs, opts?: InvokeOptions): Promise<GetSequencesResult>
function getSequencesOutput(args: GetSequencesOutputArgs, opts?: InvokeOptions): Output<GetSequencesResult>
    def get_sequences(database: Optional[str] = None,
                  like_all_patterns: Optional[Sequence[str]] = None,
                  like_any_patterns: Optional[Sequence[str]] = None,
                  not_like_all_patterns: Optional[Sequence[str]] = None,
                  regex_pattern: Optional[str] = None,
                  schemas: Optional[Sequence[str]] = None,
                  opts: Optional[InvokeOptions] = None) -> GetSequencesResult
def get_sequences_output(database: Optional[pulumi.Input[str]] = None,
                  like_all_patterns: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                  like_any_patterns: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                  not_like_all_patterns: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                  regex_pattern: Optional[pulumi.Input[str]] = None,
                  schemas: Optional[pulumi.Input[Sequence[pulumi.Input[str]]]] = None,
                  opts: Optional[InvokeOptions] = None) -> Output[GetSequencesResult]
    func GetSequences(ctx *Context, args *GetSequencesArgs, opts ...InvokeOption) (*GetSequencesResult, error)
func GetSequencesOutput(ctx *Context, args *GetSequencesOutputArgs, opts ...InvokeOption) GetSequencesResultOutput

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

    public static class GetSequences 
{
    public static Task<GetSequencesResult> InvokeAsync(GetSequencesArgs args, InvokeOptions? opts = null)
    public static Output<GetSequencesResult> Invoke(GetSequencesInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSequencesResult> getSequences(GetSequencesArgs args, InvokeOptions options)
public static Output<GetSequencesResult> getSequences(GetSequencesArgs args, InvokeOptions options)

    fn::invoke:
  function: postgresql:index/getSequences:getSequences
  arguments:
    # arguments dictionary

    The following arguments are supported:

    Database string
    The PostgreSQL database which will be queried for sequence names.
    LikeAllPatterns List<string>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ALL operators.
    LikeAnyPatterns List<string>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ANY operators.
    NotLikeAllPatterns List<string>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL NOT LIKE ALL operators.
    RegexPattern string

    Expression which will be pattern matched against sequence names in the query using the PostgreSQL ~ (regular expression match) operator.

    Note that all optional arguments can be used in conjunction.

    Schemas List<string>
    List of PostgreSQL schema(s) which will be queried for sequence names. Queries all schemas in the database by default.
    Database string
    The PostgreSQL database which will be queried for sequence names.
    LikeAllPatterns []string
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ALL operators.
    LikeAnyPatterns []string
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ANY operators.
    NotLikeAllPatterns []string
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL NOT LIKE ALL operators.
    RegexPattern string

    Expression which will be pattern matched against sequence names in the query using the PostgreSQL ~ (regular expression match) operator.

    Note that all optional arguments can be used in conjunction.

    Schemas []string
    List of PostgreSQL schema(s) which will be queried for sequence names. Queries all schemas in the database by default.
    database String
    The PostgreSQL database which will be queried for sequence names.
    likeAllPatterns List<String>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ALL operators.
    likeAnyPatterns List<String>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ANY operators.
    notLikeAllPatterns List<String>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL NOT LIKE ALL operators.
    regexPattern String

    Expression which will be pattern matched against sequence names in the query using the PostgreSQL ~ (regular expression match) operator.

    Note that all optional arguments can be used in conjunction.

    schemas List<String>
    List of PostgreSQL schema(s) which will be queried for sequence names. Queries all schemas in the database by default.
    database string
    The PostgreSQL database which will be queried for sequence names.
    likeAllPatterns string[]
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ALL operators.
    likeAnyPatterns string[]
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ANY operators.
    notLikeAllPatterns string[]
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL NOT LIKE ALL operators.
    regexPattern string

    Expression which will be pattern matched against sequence names in the query using the PostgreSQL ~ (regular expression match) operator.

    Note that all optional arguments can be used in conjunction.

    schemas string[]
    List of PostgreSQL schema(s) which will be queried for sequence names. Queries all schemas in the database by default.
    database str
    The PostgreSQL database which will be queried for sequence names.
    like_all_patterns Sequence[str]
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ALL operators.
    like_any_patterns Sequence[str]
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ANY operators.
    not_like_all_patterns Sequence[str]
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL NOT LIKE ALL operators.
    regex_pattern str

    Expression which will be pattern matched against sequence names in the query using the PostgreSQL ~ (regular expression match) operator.

    Note that all optional arguments can be used in conjunction.

    schemas Sequence[str]
    List of PostgreSQL schema(s) which will be queried for sequence names. Queries all schemas in the database by default.
    database String
    The PostgreSQL database which will be queried for sequence names.
    likeAllPatterns List<String>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ALL operators.
    likeAnyPatterns List<String>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL LIKE ANY operators.
    notLikeAllPatterns List<String>
    List of expressions which will be pattern matched against sequence names in the query using the PostgreSQL NOT LIKE ALL operators.
    regexPattern String

    Expression which will be pattern matched against sequence names in the query using the PostgreSQL ~ (regular expression match) operator.

    Note that all optional arguments can be used in conjunction.

    schemas List<String>
    List of PostgreSQL schema(s) which will be queried for sequence names. Queries all schemas in the database by default.

    getSequences Result

    The following output properties are available:

    Database string
    Id string
    The provider-assigned unique ID for this managed resource.
    Sequences List<Pulumi.PostgreSql.Outputs.GetSequencesSequence>
    A list of PostgreSQL sequences retrieved by this data source. Each sequence consists of the fields documented below.

    LikeAllPatterns List<string>
    LikeAnyPatterns List<string>
    NotLikeAllPatterns List<string>
    RegexPattern string
    Schemas List<string>
    Database string
    Id string
    The provider-assigned unique ID for this managed resource.
    Sequences []GetSequencesSequence
    A list of PostgreSQL sequences retrieved by this data source. Each sequence consists of the fields documented below.

    LikeAllPatterns []string
    LikeAnyPatterns []string
    NotLikeAllPatterns []string
    RegexPattern string
    Schemas []string
    database String
    id String
    The provider-assigned unique ID for this managed resource.
    sequences List<GetSequencesSequence>
    A list of PostgreSQL sequences retrieved by this data source. Each sequence consists of the fields documented below.

    likeAllPatterns List<String>
    likeAnyPatterns List<String>
    notLikeAllPatterns List<String>
    regexPattern String
    schemas List<String>
    database string
    id string
    The provider-assigned unique ID for this managed resource.
    sequences GetSequencesSequence[]
    A list of PostgreSQL sequences retrieved by this data source. Each sequence consists of the fields documented below.

    likeAllPatterns string[]
    likeAnyPatterns string[]
    notLikeAllPatterns string[]
    regexPattern string
    schemas string[]
    database str
    id str
    The provider-assigned unique ID for this managed resource.
    sequences Sequence[GetSequencesSequence]
    A list of PostgreSQL sequences retrieved by this data source. Each sequence consists of the fields documented below.

    like_all_patterns Sequence[str]
    like_any_patterns Sequence[str]
    not_like_all_patterns Sequence[str]
    regex_pattern str
    schemas Sequence[str]
    database String
    id String
    The provider-assigned unique ID for this managed resource.
    sequences List<Property Map>
    A list of PostgreSQL sequences retrieved by this data source. Each sequence consists of the fields documented below.

    likeAllPatterns List<String>
    likeAnyPatterns List<String>
    notLikeAllPatterns List<String>
    regexPattern String
    schemas List<String>

    Supporting Types

    GetSequencesSequence

    DataType string
    The sequence's data type as defined in information_schema.sequences.
    ObjectName string
    The sequence name.
    SchemaName string
    The parent schema.
    DataType string
    The sequence's data type as defined in information_schema.sequences.
    ObjectName string
    The sequence name.
    SchemaName string
    The parent schema.
    dataType String
    The sequence's data type as defined in information_schema.sequences.
    objectName String
    The sequence name.
    schemaName String
    The parent schema.
    dataType string
    The sequence's data type as defined in information_schema.sequences.
    objectName string
    The sequence name.
    schemaName string
    The parent schema.
    data_type str
    The sequence's data type as defined in information_schema.sequences.
    object_name str
    The sequence name.
    schema_name str
    The parent schema.
    dataType String
    The sequence's data type as defined in information_schema.sequences.
    objectName String
    The sequence name.
    schemaName String
    The parent schema.

    Package Details

    Repository
    PostgreSQL pulumi/pulumi-postgresql
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the postgresql Terraform Provider.
    postgresql logo
    PostgreSQL v3.16.0 published on Tuesday, Sep 2, 2025 by Pulumi
    pulumi/pulumi-postgresql
      Meet Neo: Your AI Platform Teammate