Re: [GENERAL] how to sync the system table with pg_dump

2008-06-05 Thread Albe Laurenz
Gary Fu wrote: > I tried to use pg_dump to restore (sync) a database, but I noticed that > the system table pg_namespace was not synced. If you restore a database, entries in pg_namespace will be created if the dump contains any CREATE SCHEMA statements, i.e. if there are schemas in your original

[GENERAL] how to sync the system table with pg_dump

2008-06-05 Thread Gary Fu
Hi, I tried to use pg_dump to restore (sync) a database, but I noticed that the system table pg_namespace was not synced. I tried the following pg_dump command to just restore that table without success either. Does pg_dump support for the system tables or something I missed ? Is there anothe