restore overwrite?

From: Anne Wainwright <anotheranne(at)fables(dot)co(dot)za>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: restore overwrite?
Date: 2022-09-07 07:50:18
Message-ID: 20220907075018.GA3923@fables.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I want to do a restore to write over the top of existing data.

The unique key prevents this. Should I rather TRUNCATE the tables
concerned before the restore? That is a bit scary if the restore does
not work. Is there a better way.

(This data on v.8.4.4 which is being moved to latest version 14).

Thanks for answer in advance

Anne

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2022-09-07 16:31:11 Re: restore overwrite?
Previous Message Bear 2022-08-29 08:59:54 Need help getting pgadmin going as portable apache app.