Postgres 12 - Generated Columns - Backup/Restore

From: Santosh Udupi <email(at)hitha(dot)net>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Postgres 12 - Generated Columns - Backup/Restore
Date: 2021-01-21 01:32:44
Message-ID: CACLRvHZTBz6vAn08VJWqayiSkTE72F-4VRWOLJ84TKHygY0q4w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

My Postgres 12 database tables have generated columns. I use pg_dump to
backup the database but when I restore using pg_restore, the generated
columns are empty. How do I trigger creating the data in the generated
columns?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2021-01-21 01:35:26 Re: Postgres 12 - Generated Columns - Backup/Restore
Previous Message Stefan Houtzager 2021-01-07 13:22:02 Re: coalesce(json_agg [..] filter where [..], '[]' in left join returning null