Postgres Pro
Downloads
Home   >   mailing lists

Postgres 12 - Generated Columns - Backup/Restore - Mailing list pgsql-novice

From Santosh Udupi
Subject Postgres 12 - Generated Columns - Backup/Restore
Date
Msg-id CACLRvHZTBz6vAn08VJWqayiSkTE72F-4VRWOLJ84TKHygY0q4w@mail.gmail.com
Whole thread Raw
Responses Re: Postgres 12 - Generated Columns - Backup/Restore
Re: Postgres 12 - Generated Columns - Backup/Restore
List pgsql-novice
Tree view
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?

pgsql-novice by date:

Previous
From: Stefan Houtzager
Date:
Subject: Re: coalesce(json_agg [..] filter where [..], '[]' in left join returning null
Next
From: Tom Lane
Date:
Subject: Re: Postgres 12 - Generated Columns - Backup/Restore