This option shows up in 7.4. On Friday 12 May 2006 10:16 am, Blair Lowe wrote: > On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote: > > On Friday 12 May 2006 09:50 am, Blair Lowe wrote: > > See following- > > -n schema > > --schema=schema > > > > Dump the contents of schema only. If this option is not specified, > > all non-system schemas in the target database will be dumped. > > > > Note: In this mode, pg_dump makes no attempt to dump any other > > database objects that objects in the selected schema may depend upon. > > Therefore, there is no guarantee that the results of a single-schema dump > > can be successfully restored by themselves into a clean database. > > In postgreSQL version 7.3.4: > > user# pg_dump -n <schema_name> > tmp95.sql > pg_dump: invalid option -- n > Try 'pg_dump --help' for more information. > > phpbb only works with version 7.x. > > TTYL, > Blair. > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Adrian Klaver aklaver@xxxxxxxxxxx