To: Greg Williamson <gwilliamson39@yahoo.com>
cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: postgres 9.0.4, pg_restore and indexes 
In-reply-to: <1319503267.66489.YahooMailNeo@web46110.mail.sp1.yahoo.com> 
References: <1319493368.35732.YahooMailNeo@web46108.mail.sp1.yahoo.com>
	<CALnrrJQiBwb4ym1DBASzQR2pbdPnYueJmQWwOXSweKhpa-cYxA@mail.gmail.com>
	<1319503267.66489.YahooMailNeo@web46110.mail.sp1.yahoo.com>
Comments: In-reply-to Greg Williamson <gwilliamson39@yahoo.com>
	message dated "Mon, 24 Oct 2011 17:41:07 -0700"
Date: Mon, 24 Oct 2011 21:10:44 -0400
Message-ID: <10444.1319505044@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Greg Williamson <gwilliamson39@yahoo.com> writes:
> What I am I missing ? Or is pg_restore just not capable of restoring the full definition of a table ?

There isn't any provision for doing that automatically; it would be a
bit tough to determine exactly what the "full definition" consists of
in a way that makes everybody happy.  (For instance, how about tables
that are targets of foreign key references?  Functions that are depended
on by check constraints or indexes?  And so on.)

What you can do is use the --list option to get a list of all the
objects in the dump, edit that down to what you want, then use the
--use-list option to restore the stuff in your abbreviated list.

			regards, tom lane