Re: [ADMIN] How to correlate an index relname to it's table

2007-11-20 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 20 Nov 2007 10:48:18 -0700 Kevin Kempter <[EMAIL PROTECTED]> wrote: > Hi List; > > I've got an index name in pg_class and I want to figure out which > table it belongs to, any suggestions? > Well you can get the name from pg_indexes as well

[ADMIN] How to correlate an index relname to it's table

2007-11-20 Thread Kevin Kempter
Hi List; I've got an index name in pg_class and I want to figure out which table it belongs to, any suggestions? Thanks in advance /Kevin ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choo