On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR <
venkteshguttedar(at)gmail(dot)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.