pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How to correlate an index relname to it's table 2+ messages / 2 participants [nested] [flat]
* How to correlate an index relname to it's table @ 2007-11-20 17:48 Kevin Kempter <kevin@kevinkempterllc.com> 0 siblings, 1 reply; 2+ messages in thread From: Kevin Kempter @ 2007-11-20 17:48 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to correlate an index relname to it's table @ 2007-11-20 17:54 Joshua D. Drake <jd@commandprompt.com> parent: Kevin Kempter <kevin@kevinkempterllc.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2007-11-20 17:54 UTC (permalink / raw) To: Kevin Kempter <kevin@kevinkempterllc.com>; +Cc: pgsql-admin -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 20 Nov 2007 10:48:18 -0700 Kevin Kempter <kevin@kevinkempterllc.com> 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 as the schemaname, tablename and indexname :) Sincerely, Joshua D. Drake > > Thanks in advance > > > /Kevin > > > ---------------------------(end of > broadcast)--------------------------- TIP 9: In versions below 8.0, > the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHQx8+ATb/zqfZUUQRAsDAAJ9nLHGejnPjfkSkvFvuswsJaP44ygCfRjeV leWQAhiLAnKaO7Pzjjnx8ZA= =9HCE -----END PGP SIGNATURE----- ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-11-20 17:54 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-11-20 17:48 How to correlate an index relname to it's table Kevin Kempter <kevin@kevinkempterllc.com> 2007-11-20 17:54 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox