Re: Slony v. DBMirror

On Fri, May 06, 2005 at 12:09:14PM -0400, Chris Browne wrote:
> What I need, for that, is a way of grabbing all the index definitions
> for the table. One way to do that would be to run "pg_dump -s -t a",
> though I'd rather have a method that uses the connection I already
> have to the database.
>
> This may involve some more-or-less involved queries on pg_index,
> unless the pg_indexes view is available on all versions of PG of
> interest...

You'll want to take a look at newsysviews on pgFoundry. Even if you
decide not to depend on it (though hopefully it'll get built into 8.1)
the index views should get you pretty close to what you need for
generating index definition statements. If there's anything missing let
me know.
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"