| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Mike L <giantmetfan(at)comcast(dot)net> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Create Publication v12 |
| Date: | 2025-02-26 20:22:16 |
| Message-ID: | CAKFQuwaYiBh1aSCDnH+scBUiAGvufD1jfFJi6+phbMkZsfLp2Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, Feb 26, 2025 at 1:17 PM Mike L <giantmetfan(at)comcast(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thiemo Kellner | 2025-02-26 20:32:46 | Create Publication v12 |
| Previous Message | Mike L | 2025-02-26 20:16:20 | Create Publication v12 |