Re: schema diff tool problem with owner statements

2021-11-11 Thread Akshay Joshi
Hi On Fri, Nov 12, 2021 at 12:45 AM wrote: > I'm trying to compare 2 schemas (devschema is the source and testschema > is the target) and generate a script that can be run on the target that > will create the missing tables. I ran the schema diff, and it generated > items like this: > > CREATE

schema diff tool problem with owner statements

2021-11-11 Thread postgresql
I'm trying to compare 2 schemas (devschema is the source and testschema is the target) and generate a script that can be run on the target that will create the missing tables.  I ran the schema diff, and it generated items like this: CREATE TABLE IF NOT EXISTS tablename ( fields, etc ) TABLESP

Re: need help in restoring from tar file

2021-11-11 Thread Aditya Toshniwal
Hi Rekha, Please set the binary paths here - https://www.pgadmin.org/docs/pgadmin4/6.1/preferences.html#the-paths-node On Thu, Nov 11, 2021 at 2:20 PM Rekha Singh wrote: > Hello, > > I get this message - > 'C:\Users\rekha\pg_restore.exe' file not found. Please correct the Binary > Path in the

need help in restoring from tar file

2021-11-11 Thread Rekha Singh
Hello, I get this message - 'C:\Users\rekha\pg_restore.exe' file not found. Please correct the Binary Path in the Preferences dialog' How do I proceed? Thank you, Rekha