Postgres Pro
Downloads
Home   >   mailing lists

Thread: Create Publication v12

Create Publication v12

From
Mike L
Date:
I understand in version 15 functionality was added to allow to create a publication for all tables within a schema. How would I need to do this in v12?
Ex.
Schema1:
Table1
Table2

Schema2:
Table1
Table2

?

The documentation for 12 does not show schema.table just table names

Thanks in advanced.

Re: Create Publication v12

From
"David G. Johnston"
Date:
On Wed, Feb 26, 2025 at 1:17 PM Mike L <giantmetfan@comcast.net> wrote:
I understand in version 15 functionality was added to allow to create a publication for all tables within a schema. How would I need to do this in v12?

If it's a newly added feature in v15 there isn't a way to do the exact same thing in v12.  In v12 you can get auto-add and wildcard on the full database only.  If you need a subset, schema-based or otherwise, you need to list every entry and you will not have an auto-add behavior.
 

The documentation for 12 does not show schema.table just table names

Anywhere you can write a table name should be able to accept the full, schema-qualified, name even when it isn't called out explicitly.

David J.

Create Publication v12

From
Thiemo Kellner
Date:
If it has been added to v15, why not upgrade to the newest version? Sounds to me like a sound use case.