Hi, Le 20/04/2010 18:18, Kieran McCusker a écrit : > [...] > Sorry if this has been raised before but I have just tried to restore a > table from one of my schemas. > > The problem was that this table name is very common - It is used in many > schemas as each schema is the data for an individual client. > > Restore has the three disabled checkboxes > Only data (checked) > Only schema (unchecked) > Single object (checked) > > and then below > Table (my table name) > > I assumed was it was going to restore only the selected table - What it > actually did was restore all tables with that name! >
Yes, the Restore window launches pg_restore with the --table option, but doesn't specify the schema name. > This seems confusing at best (and how would you do what I wanted using > the UI?) > There's no way to do this with the UI. But this is a bug and should be fixed. > Shouldn't the schema be checked as well? > Yes. The good behaviour is already available in the backup window. I just need to push it also in the restore window. Will do this evening. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
