Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Fri, Mar 03, 2006 at 05:46:59PM +1100, Chris wrote:
>> If I look at an index:
>> It doesn't show me which fields it actually applies to, only the table.
> \d news_pkey
Also, \d on the index's parent table will show you all the index
definitions. Thi
Michael Fuhr wrote:
On Fri, Mar 03, 2006 at 05:46:59PM +1100, Chris wrote:
If I look at an index:
\di+ news_pkey
Schema | Name | Type | Owner | Description | Table
+---+---+---+-+
public | news_pkey | index | chris | | news
It do
On Fri, Mar 03, 2006 at 05:46:59PM +1100, Chris wrote:
> If I look at an index:
>
> \di+ news_pkey
>
> Schema | Name | Type | Owner | Description | Table
> +---+---+---+-+
> public | news_pkey | index | chris | | news
>
>
> It does
Hi all,
I'm trying to work out which fields an index relates to.
If I look at an index:
\di+ news_pkey
Schema | Name | Type | Owner | Description | Table
+---+---+---+-+
public | news_pkey | index | chris | | news
It doesn't sho
