Try this command on the command-prompt: "C:\Program Files\PostgreSQL\9.4\bin\pg_restore.exe" --host localhost --port 5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password --data-only --table "\"user\"" --schema xyz1 --verbose "E:\20150611 Mig32QA user4.backup"
-- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company <http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi* <http://www.linkedin.com/in/asheshvashi> On Mon, Jun 15, 2015 at 11:04 PM, Soule, Cathi (HQP) < cathi.so...@roberthalf.com> wrote: > Hello, > > > > We are not able to restore a table using pgAdmin from object browser. We > have been successful using backup / restore functions with 30 other > tables. However, we are not able to restore one table named ‘user’. Here > are details: Thank you! > > > > - pgAdmin version 1.20.0 > > - Windows 7, 64-bit > > > > Messages returned is as follows. Note that a successful restore had 2 > additional msgs (pg_restore: processing data for table "skillc" pg_restore: > setting owner and privileges for TABLE DATA skillc). Defaults were used on > backup and restore. Does anyone know how to resolve? Thank you for any > help! > > > > > > MESSAGES RETURNED FROM UNSUCCESSFUL RESTORE-- > > C:/Program Files/PostgreSQL/9.4/bin\pg_restore.exe --host localhost --port > > 5432 --username "postgres" --dbname "d27qs7oej1f23" --no-password > --data-only --table \"user\" --schema xyz1 --verbose "E:\20150611 Mig32QA > user4.backup" > > pg_restore: connecting to database for restore Process returned exit code > 0. > > > > > > > > Cathi Soule > > cathi.so...@roberthalf.com > > >
