Re: Unable to Restor Table Named "User"

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(dot)soule(at)roberthalf(dot)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(dot)Soule(at)roberthalf(dot)com
>
>
>