--- title: Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE... description: PostgreSQL 19 extends ALTER PUBLICATION to support the EXCEPT TABLE clause, complementing the earlier CREATE PUBLICATION EXCEPT TABLE feature. The new syntax... canonical: https://daily.dev/posts/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication-select-from-depes-8ngexy8y6 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION. – select * from depesz; | daily.dev og:description: PostgreSQL 19 extends ALTER PUBLICATION to support the EXCEPT TABLE clause, complementing the earlier CREATE PUBLICATION EXCEPT TABLE feature. The new syntax... og:url: https://daily.dev/posts/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication-select-from-depes-8ngexy8y6 og:image: https://api.daily.dev/og/posts/8NGEXY8Y6.png og:image:alt: Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION. – select * from depesz; og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION. – select * from depesz; **[depesz](https://daily.dev/sources/depesz)** · 4 min read · 0 upvotes · 0 comments ## Summary PostgreSQL 19 extends ALTER PUBLICATION to support the EXCEPT TABLE clause, complementing the earlier CREATE PUBLICATION EXCEPT TABLE feature. The new syntax allows modifying the exclusion list for publications that cover ALL TABLES. When SET ALL TABLES EXCEPT TABLE is used, the existing exclusion list is fully replaced by the specified tables — it does not merge with the previous list. Practical examples demonstrate creating publications, excluding specific tables, and updating exclusion lists across multiple publications. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Waiting for PostgreSQL 19 – Allow table exclusions in publications via EXCEPT TABLE. – select \* from depesz;](https://daily.dev/posts/waiting-for-postgresql-19-allow-table-exclusions-in-publications-via-except-table-select-from-4olx2jvo1) · depesz · 0 upvotes · 0 comments - [Looking Forward to Postgres 19: It's About Time](https://daily.dev/posts/looking-forward-to-postgres-19-it-s-about-time-chhpnhwmp) · Planet PostgreSQL · 0 upvotes · 0 comments - [9 Advanced PostgreSQL Features I Wish I Knew Sooner](https://daily.dev/posts/9-advanced-postgresql-features-i-wish-i-knew-sooner-nezidnbnu) · marmelab · 115 upvotes · 0 comments - [Waiting for PostgreSQL 19 – Support COPY TO for partitioned tables. – select \* from depesz;](https://daily.dev/posts/waiting-for-postgresql-19-support-copy-to-for-partitioned-tables-select-from-depesz--ryskyymw6) · depesz · 6 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication-select-from-depes-8ngexy8y6) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION. – select * from depesz;","url":"https://daily.dev/posts/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication-select-from-depes-8ngexy8y6","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication-select-from-depes-8ngexy8y6"},"datePublished":"2026-03-26T11:50:09.446Z","dateModified":"2026-03-26T11:50:34.260Z","description":"PostgreSQL 19 extends ALTER PUBLICATION to support the EXCEPT TABLE clause, complementing the earlier CREATE PUBLICATION EXCEPT TABLE feature. The new syntax...","image":"https://media.daily.dev/image/upload/s--OHB84bZF--/f_auto/v1722860399/public/Placeholder%2010","thumbnailUrl":"https://media.daily.dev/image/upload/s--OHB84bZF--/f_auto/v1722860399/public/Placeholder%2010","isAccessibleForFree":true,"articleSection":"depesz","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"depesz","logo":"https://media.daily.dev/image/upload/s--ir7juGOi--/f_auto/v1758461024/logos/depesz","url":"https://daily.dev/sources/depesz"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/waiting-for-postgresql-19-add-support-for-except-table-in-alter-publication-select-from-depes-8ngexy8y6","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"backend,postgresql","timeRequired":"PT4M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"depesz","item":"https://daily.dev/sources/depesz"},{"@type":"ListItem","position":3,"name":"Waiting for PostgreSQL 19 – Add support for EXCEPT TABLE in ALTER PUBLICATION. – select * from depesz;"}]} ```