Re: Postgres 12 - Generated Columns - Backup/Restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Santosh Udupi <email(at)hitha(dot)net>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres 12 - Generated Columns - Backup/Restore
Date: 2021-01-21 01:35:26
Message-ID: 798384.1611192926@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Santosh Udupi <email(at)hitha(dot)net> writes:
> 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?

Can you give a fleshed-out example of what you're doing?

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2021-01-21 12:36:14 Re: Postgres 12 - Generated Columns - Backup/Restore
Previous Message Santosh Udupi 2021-01-21 01:32:44 Postgres 12 - Generated Columns - Backup/Restore