> On 28 Nov 2017, at 16:43, David G. Johnston <david.g.johns...@gmail.com> > wrote: > > On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR > <venkteshgutte...@gmail.com> wrote: > I have run CREATE SCHEMA xyz accidentally, and it replaced my existing > schema (xyz) with tables, and i have lost all my data. > > As far as I know "CREATE SCHEMA" by itself cannot "drop" data nor would it > successfully execute if a schema of the same name already exist... > > As Melvin says if you've truly dropped the data you will need to resort to > backups of some form. > > David J.
Just what I was thinking. Are you looking in the correct database? Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest.
