Skip site navigation (1) Skip section navigation (2)

Retrieving the keys in an index

From: Alex Rasmussen <alex(dot)c(dot)rasmussen(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Retrieving the keys in an index
Date: 2006-09-10 08:00:44
Message-ID: 0BCBE377-87C0-49E5-86C2-A602548BB835@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I'd like to know if it's possible to get either of the following two  
things from psql as a relation:

1. a list of all the b-trees applying to a table or tables in a given  
database
2. given the name of one of the aforementioned b-trees, a list of all  
keys currently being used in the index.

If anyone could point me in the right direction, I'd be very  
appreciative.

--Alex
--
Alex Rasmussen
alex(dot)c(dot)rasmussen(at)gmail(dot)com
http://www.alexras.info/



pgsql-novice by date

Next:From: roy simkesDate: 2006-09-10 10:25:57
Subject: install pgadmin3 on suse10
Previous:From: operationsengineer1Date: 2006-09-10 02:36:56
Subject: Re: Progress and Questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group