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@xxxxxxxxxxx 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?" ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
