Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Postgres 12 - Generated Columns - Backup/Restore
Date
Msg-id 798384.1611192926@sss.pgh.pa.us
Whole thread Raw
In response to Postgres 12 - Generated Columns - Backup/Restore  (Santosh Udupi <email@hitha.net>)
List pgsql-novice
Tree view 
Santosh Udupi <email@hitha.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

pgsql-novice by date:

Previous
From: Santosh Udupi
Date:
Subject: Postgres 12 - Generated Columns - Backup/Restore
Next
From: Laurenz Albe
Date:
Subject: Re: Postgres 12 - Generated Columns - Backup/Restore