On 2024-12-03 18:43 +0100, Sasmit Utkarsh wrote:
> I am working on a project that uses libpq along with C language to interact
> with PostgreSQL, and we face challenges with managing schema changes
> dynamically in production while avoiding downtime. Specifically, we need
> guidance on handling tab
On 12/3/24 09:43, Sasmit Utkarsh wrote:
Dear PostgreSQL Community Team,
I am working on a project that uses libpq along with C language to
interact with PostgreSQL, and we face challenges with managing schema
changes dynamically in production while avoiding downtime. Specifically,
we need gui
On Tue, Dec 3, 2024 at 12:44 PM Sasmit Utkarsh
wrote:
[snip]
> How can we efficiently handle table additions/updates while keeping the
> application and database in sync dynamically?
>
Enumerate all relevant column names in SELECT and INSERT statements. That
way, the application still works whe
Dear PostgreSQL Community Team,
I am working on a project that uses libpq along with C language to interact
with PostgreSQL, and we face challenges with managing schema changes
dynamically in production while avoiding downtime. Specifically, we need
guidance on handling table structure changes/add
