Re: can recs be transferred between DBs ?

On 4/28/26 8:56 AM, dfgpostgres wrote:
> psql (15.3, server 15.15) on linux
> 
> dvdb=# \d arch_restore
>                    Table "misc.arch_restore"
>   Column |       Type        | Collation | Nullable | Default
> --------+-------------------+-----------+----------+---------
>   pk     | integer           |           | not null |
>   proj   | character varying |           |          |
>   data   | character varying |           |          |
> Indexes:
>      "arch_restore_pkey" PRIMARY KEY, btree (pk)
> 
> dvdb=# select * from arch_restore order by pk;
>   pk | proj  |    data
> ----+-------+------------
>    1 | alpha | the_data_1
>    2 | alpha | the_data_2
>    3 | alpha | the_data_3
>    4 | beta  | the_data_4
>    5 | beta  | the_data_5
>    6 | beta  | the_data_6
>    7 | gamma | the_data_7
>    8 | gamma | the_data_8
>    9 | gamma | the_data_9
> (9 rows)
> 
> I decided that it's time to archive the 'beta' project.  So I create a 
> new DB in the PG instance and put them all there leaving...

How did you transfer the data to the new database and could you not use 
the same process to transfer the beta data back?

> 
> Thanks in Advance