↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Versions

Logical replication publish all tables in schema

Recorded source states and original language descriptions. Missing version evidence stays unknown.

The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.

Replication

Description

When creating a logical replication publication, a user can specify to publish all the tables within a schema , e.g. CREATE PUBLICATION ... FOR TABLES IN SCHEMA ....

Selected version: PostgreSQL 18

Yes

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownYesYesYesYesNoNoNoNoNoNoNoNoNoNoNoNoNoNoNoNoUnknownUnknown

Compare versions

Original documentation links

Recorded legacy identifiers: 391

Complete source facts and provenance

yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd

{
  "Key": "logical-replication-publish-all-tables-in-schema",
  "SourceKind": "yaml",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix.yaml",
  "SourceKey": "Logical replication publish all tables in schema",
  "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
  "Name": "Logical replication publish all tables in schema",
  "NameLocale": "en",
  "GroupKey": "replication",
  "GroupName": "Replication",
  "GroupLocale": "en",
  "Ordinal": 13,
  "GroupOrder": 9,
  "Facts": {
    "feature": {
      "description": "When creating a logical replication publication, a user can specify to publish all the tables within a schema , e.g. [`CREATE PUBLICATION ... FOR TABLES IN SCHEMA ...`](https://www.postgresql.org/docs/15/sql-createpublication.html).",
      "name": "Logical replication publish all tables in schema",
      "versions": {
        "15": "Yes"
      }
    },
    "group": "Replication",
    "versions": {
      "max": 18,
      "min": 8.1
    }
  },
  "Cells": [
    {
      "Version": "10",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "11",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "12",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "13",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "14",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "15",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "15",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "16",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "15",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "17",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "15",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "18",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "15",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.1",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.2",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.3",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.4",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.0",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.1",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.2",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.3",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.4",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.5",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.6",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "Logical replication publish all tables in schema",
      "BodyHTML": "\u003cp\u003eWhen creating a logical replication publication, a user can specify to publish all the tables within a schema , e.g. \u003ca href=\"https://www.postgresql.org/docs/15/sql-createpublication.html\" rel=\"nofollow\"\u003e\u003ccode\u003eCREATE PUBLICATION ... FOR TABLES IN SCHEMA ...\u003c/code\u003e\u003c/a\u003e.\u003c/p\u003e\n",
      "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
      "ContentHash": "4cb79be6a13f889e5e8ac713369f379390e4d07a878e6a275f66be96259b3365",
      "Payload": {
        "description": "When creating a logical replication publication, a user can specify to publish all the tables within a schema , e.g. [`CREATE PUBLICATION ... FOR TABLES IN SCHEMA ...`](https://www.postgresql.org/docs/15/sql-createpublication.html).",
        "name": "Logical replication publish all tables in schema",
        "versions": {
          "15": "Yes"
        }
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "逻辑复制发布 模式 中的全部表",
      "BodyHTML": "\u003cp\u003e创建 发布 时,现在可以指定发布某个 模式 下的全部表。\u003c/p\u003e\n",
      "SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
      "ContentHash": "4d1a004db8ac6fad395f6822d61512324bb3c7042f375900b4c8914892d3059f",
      "Payload": {
        "description": "创建 发布 时,现在可以指定发布某个 模式 下的全部表。",
        "name": "逻辑复制发布 模式 中的全部表"
      }
    }
  ],
  "GroupTitles": {
    "en": "Replication",
    "zh-Hans": "复制"
  },
  "LegacyIDs": [
    "391"
  ]
}

Complete source data JSON