Re: [GENERAL] - Regarding Schema ROLLBACK - Mailing list pgsql-general

> On 28 Nov 2017, at 16:43, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR <venkteshguttedar@gmail.com> wrote:
>     I have run CREATE SCHEMA xyz accidentally, and it replaced my existing schema (xyz) with tables, and i have lost
allmy data. 
>
> ​As far as I know "CREATE SCHEMA" by itself cannot "drop" data nor would it successfully execute if a schema of the
samename 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.