Docs Packages
  1. Packages
  2. PostgreSQL
  3. API Docs
  4. Publication
PostgreSQL v3.10.0 published on Friday, Sep 22, 2023 by Pulumi
pulumi/pulumi-postgresql

postgresql.Publication

Explore with Pulumi AI

postgresql logo
PostgreSQL v3.10.0 published on Friday, Sep 22, 2023 by Pulumi
pulumi/pulumi-postgresql

    The postgresql.Publication resource creates and manages a publication on a PostgreSQL server.

    Usage

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

const publication = new postgresql.Publication("publication", {tables: [
    "public.test",
    "another_schema.test",
]});

    import pulumi
import pulumi_postgresql as postgresql

publication = postgresql.Publication("publication", tables=[
    "public.test",
    "another_schema.test",
])

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

return await Deployment.RunAsync(() => 
{
    var publication = new PostgreSql.Publication("publication", new()
    {
        Tables = new[]
        {
            "public.test",
            "another_schema.test",
        },
    });

});

    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.NewPublication(ctx, "publication", &postgresql.PublicationArgs{
			Tables: pulumi.StringArray{
				pulumi.String("public.test"),
				pulumi.String("another_schema.test"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.postgresql.Publication;
import com.pulumi.postgresql.PublicationArgs;
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) {
        var publication = new Publication("publication", PublicationArgs.builder()        
            .tables(            
                "public.test",
                "another_schema.test")
            .build());

    }
}

    resources:
  publication:
    type: postgresql:Publication
    properties:
      tables:
        - public.test
        - another_schema.test

    Create Publication Resource

    new Publication(name: string, args?: PublicationArgs, opts?: CustomResourceOptions);
    @overload
def Publication(resource_name: str,
                opts: Optional[ResourceOptions] = None,
                all_tables: Optional[bool] = None,
                database: Optional[str] = None,
                drop_cascade: Optional[bool] = None,
                name: Optional[str] = None,
                owner: Optional[str] = None,
                publish_params: Optional[Sequence[str]] = None,
                publish_via_partition_root_param: Optional[bool] = None,
                tables: Optional[Sequence[str]] = None)
@overload
def Publication(resource_name: str,
                args: Optional[PublicationArgs] = None,
                opts: Optional[ResourceOptions] = None)
    func NewPublication(ctx *Context, name string, args *PublicationArgs, opts ...ResourceOption) (*Publication, error)
    public Publication(string name, PublicationArgs? args = null, CustomResourceOptions? opts = null)
    public Publication(String name, PublicationArgs args)
public Publication(String name, PublicationArgs args, CustomResourceOptions options)

    type: postgresql:Publication
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args PublicationArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args PublicationArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args PublicationArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args PublicationArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args PublicationArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Publication Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    The Publication resource accepts the following input properties:

    AllTables bool

    Should be ALL TABLES added to the publication. Defaults to 'false'

    Database string

    Which database to create the publication on. Defaults to provider database.

    DropCascade bool

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    Name string

    The name of the publication.

    Owner string

    Who owns the publication. Defaults to provider user.

    PublishParams List<string>

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    PublishViaPartitionRootParam bool

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    Tables List<string>

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    AllTables bool

    Should be ALL TABLES added to the publication. Defaults to 'false'

    Database string

    Which database to create the publication on. Defaults to provider database.

    DropCascade bool

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    Name string

    The name of the publication.

    Owner string

    Who owns the publication. Defaults to provider user.

    PublishParams []string

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    PublishViaPartitionRootParam bool

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    Tables []string

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    allTables Boolean

    Should be ALL TABLES added to the publication. Defaults to 'false'

    database String

    Which database to create the publication on. Defaults to provider database.

    dropCascade Boolean

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    name String

    The name of the publication.

    owner String

    Who owns the publication. Defaults to provider user.

    publishParams List<String>

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    publishViaPartitionRootParam Boolean

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    tables List<String>

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    allTables boolean

    Should be ALL TABLES added to the publication. Defaults to 'false'

    database string

    Which database to create the publication on. Defaults to provider database.

    dropCascade boolean

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    name string

    The name of the publication.

    owner string

    Who owns the publication. Defaults to provider user.

    publishParams string[]

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    publishViaPartitionRootParam boolean

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    tables string[]

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    all_tables bool

    Should be ALL TABLES added to the publication. Defaults to 'false'

    database str

    Which database to create the publication on. Defaults to provider database.

    drop_cascade bool

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    name str

    The name of the publication.

    owner str

    Who owns the publication. Defaults to provider user.

    publish_params Sequence[str]

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    publish_via_partition_root_param bool

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    tables Sequence[str]

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    allTables Boolean

    Should be ALL TABLES added to the publication. Defaults to 'false'

    database String

    Which database to create the publication on. Defaults to provider database.

    dropCascade Boolean

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    name String

    The name of the publication.

    owner String

    Who owns the publication. Defaults to provider user.

    publishParams List<String>

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    publishViaPartitionRootParam Boolean

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    tables List<String>

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the Publication resource produces the following output properties:

    Id string

    The provider-assigned unique ID for this managed resource.

    Id string

    The provider-assigned unique ID for this managed resource.

    id String

    The provider-assigned unique ID for this managed resource.

    id string

    The provider-assigned unique ID for this managed resource.

    id str

    The provider-assigned unique ID for this managed resource.

    id String

    The provider-assigned unique ID for this managed resource.

    Look up Existing Publication Resource

    Get an existing Publication resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: PublicationState, opts?: CustomResourceOptions): Publication
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        all_tables: Optional[bool] = None,
        database: Optional[str] = None,
        drop_cascade: Optional[bool] = None,
        name: Optional[str] = None,
        owner: Optional[str] = None,
        publish_params: Optional[Sequence[str]] = None,
        publish_via_partition_root_param: Optional[bool] = None,
        tables: Optional[Sequence[str]] = None) -> Publication
    func GetPublication(ctx *Context, name string, id IDInput, state *PublicationState, opts ...ResourceOption) (*Publication, error)
    public static Publication Get(string name, Input<string> id, PublicationState? state, CustomResourceOptions? opts = null)
    public static Publication get(String name, Output<String> id, PublicationState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AllTables bool

    Should be ALL TABLES added to the publication. Defaults to 'false'

    Database string

    Which database to create the publication on. Defaults to provider database.

    DropCascade bool

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    Name string

    The name of the publication.

    Owner string

    Who owns the publication. Defaults to provider user.

    PublishParams List<string>

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    PublishViaPartitionRootParam bool

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    Tables List<string>

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    AllTables bool

    Should be ALL TABLES added to the publication. Defaults to 'false'

    Database string

    Which database to create the publication on. Defaults to provider database.

    DropCascade bool

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    Name string

    The name of the publication.

    Owner string

    Who owns the publication. Defaults to provider user.

    PublishParams []string

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    PublishViaPartitionRootParam bool

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    Tables []string

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    allTables Boolean

    Should be ALL TABLES added to the publication. Defaults to 'false'

    database String

    Which database to create the publication on. Defaults to provider database.

    dropCascade Boolean

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    name String

    The name of the publication.

    owner String

    Who owns the publication. Defaults to provider user.

    publishParams List<String>

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    publishViaPartitionRootParam Boolean

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    tables List<String>

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    allTables boolean

    Should be ALL TABLES added to the publication. Defaults to 'false'

    database string

    Which database to create the publication on. Defaults to provider database.

    dropCascade boolean

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    name string

    The name of the publication.

    owner string

    Who owns the publication. Defaults to provider user.

    publishParams string[]

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    publishViaPartitionRootParam boolean

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    tables string[]

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    all_tables bool

    Should be ALL TABLES added to the publication. Defaults to 'false'

    database str

    Which database to create the publication on. Defaults to provider database.

    drop_cascade bool

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    name str

    The name of the publication.

    owner str

    Who owns the publication. Defaults to provider user.

    publish_params Sequence[str]

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    publish_via_partition_root_param bool

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    tables Sequence[str]

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    allTables Boolean

    Should be ALL TABLES added to the publication. Defaults to 'false'

    database String

    Which database to create the publication on. Defaults to provider database.

    dropCascade Boolean

    Should all subsequent resources of the publication be dropped. Defaults to 'false'

    name String

    The name of the publication.

    owner String

    Who owns the publication. Defaults to provider user.

    publishParams List<String>

    Which 'publish' options should be turned on. Default to 'insert','update','delete'

    publishViaPartitionRootParam Boolean

    Should be option 'publish_via_partition_root' be turned on. Default to 'false'

    tables List<String>

    Which tables add to the publication. By defaults no tables added. Format of table is <schema_name>.<table_name>. If <schema_name> is not specified - default database schema will be used. Table string must be listed in alphabetical order.

    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.10.0 published on Friday, Sep 22, 2023 by Pulumi
    pulumi/pulumi-postgresql