Re: Table level restore in postgres

2024-03-28 Thread Ron Johnson
On Thu, Mar 28, 2024 at 2:27 PM arun chirappurath wrote: > Dear all, > > I am a new bie in postgres world > > Suppose I have accidently deleted a table or deleted few rows ,is it safe > to drop this table and restore just this table from custom backup to same > database? > By "custom

Re: Table level restore in postgres

2024-03-28 Thread Adrian Klaver
On 3/28/24 11:27, arun chirappurath wrote: Dear all, I am a new bie in postgres world Suppose I have accidently deleted a table or deleted few rows ,is it safe to drop this table and restore just this table from custom backup to same database? 1) You can though depending on when you

Table level restore in postgres

2024-03-28 Thread arun chirappurath
Dear all, I am a new bie in postgres world Suppose I have accidently deleted a table or deleted few rows ,is it safe to drop this table and restore just this table from custom backup to same database? Or should I create a new database and restore it there and then migrate the data? What is