Re: BUG #13438: Restore using GUI client - Data Not Loading

To clarify - we are trying to restore the 'user' table using pgAdmin III 'restore' function. This function is selected after right-click on table in schema in Object browser. We successfully used 'backup' and 'restore' in pgAdmin III GUI on 30 tables. This 'user' table has been the only issue. Thanks again for your help.

-----Original Message-----
From: Soule, Cathi (HQP)
Sent: Monday, June 15, 2015 7:37 AM
To: 'Tom Lane'
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: RE: [BUGS] BUG #13438: Restore using GUI client - Data Not Loading

Hi Tom,

I am using the GUI to try and 'restore' the 'user' table - which was backed up using the GUI 'backup' function. Is there a way to 'leave off all that decoration' as you suggest below - using the GUI? Unfortunately I don't know my way around in native environment. We do have 'PSQL Console' plugin - although I have not been successful trying to restore here. That is why we were relying on the GUI - which worked great for all our other tables.

Thank you very much for your help,

Cathi Soule

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Saturday, June 13, 2015 8:57 AM
To: Soule, Cathi (HQP)
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #13438: Restore using GUI client - Data Not Loading

cathi(dot)soule(at)roberthalf(dot)com writes:
> Hello, I am trying to backup / restore a table named 'user' using
> Postgres GUI/client. The restore does not load data. I suspect the
> issue may be the tablename 'user' (not my table). The backup msgs are
> listed below. My other successful restores 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!

> 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.

I'm not real sure what backslashes do in the Windows command interpreter, but I bet the problem is that what pg_restore is getting as the argument of the --table switch is not just user but something with quote marks and/or backslashes in it, and that's not matching any table name it can find in the file so it doesn't restore anything.

Try leaving off all that decoration. "user" is not a keyword as far as the shell is concerned, so it doesn't really need quoting in this context.

regards, tom lane