Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id A1FCC63EDBC
	for <pgsql-docs-postgresql.org@mail.postgresql.org>;
	Mon, 29 Jun 2009 15:17:03 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 38593-01-8 for
	<pgsql-docs-postgresql.org@mail.postgresql.org>;
	Mon, 29 Jun 2009 15:17:02 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from pobox.sfu.ca (pobox.sfu.ca [142.58.101.28])
	by mail.postgresql.org (Postfix) with ESMTP id AE2E363584E
	for <pgsql-docs@postgresql.org>; Mon, 29 Jun 2009 15:15:29 -0300 (ADT)
Received: from [192.168.123.25] (s142-179-66-77.bc.hsia.telus.net
	[142.179.66.77]) (authenticated bits=0)
	by pobox.sfu.ca (8.13.6/8.13.5/SFU-6.0G) with ESMTP id n5TIFQXD021294
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <pgsql-docs@postgresql.org>; Mon, 29 Jun 2009 11:15:28 -0700 (PDT)
Message-ID: <4A4904BE.2070306@sfu.ca>
Date: Mon, 29 Jun 2009 11:15:26 -0700
From: Mike Toews <mwtoews@sfu.ca>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: Improve pg_restore docs
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200906/12
X-Sequence-Number: 5193

Hi,

 From a quick discussion on hackers 
(http://archives.postgresql.org/pgsql-hackers/2009-06/msg01434.php), it 
appears the documentation can improve for pg_restore.

I've prepared some quick diff output from 
pgsql/doc/src/sgml/ref/pg_restore.sgml for some changes that I think 
would help. Note that I'm not entirely sure about the default namespace 
from default_path .. please verify this before accepting. Edit as necessary.

291c291,292
<         specific table.
---
 >         specific table.  The default is taken from the
 >         <envar>default_path</envar> variable.
379c380,382
<         Restore definition and/or data of named table only.
---
 >         Restore definition and/or data of named table only. This can be
 >         combined with the <option>-n</option> option to restore a table
 >         from a specific schema.


Thanks,

-Mike