Re: Are foreign key's automatically set as indicies? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Are foreign key's automatically set as indicies?
Date
Msg-id 464F11FE.70205@iol.ie
Whole thread Raw
In response to Are foreign key's automatically set as indicies?  (camb <mvpaustralia@gmail.com>)
List pgsql-general
On 16/05/2007 05:09, camb wrote:

> I'm sorta new to PG and am just wondering, when I create a foreign key
> is it automatically set as an indexed column or do I need to also set
> that manually?

AFAIK you need to create the index separately. I use PgAdmin most of the
time, which does that by default, so I'm a bit hazy on doing it by hand.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: filippo
Date:
Subject: change database encoding without corrupting data (latin9 to utf8)
Next
From: PFC
Date:
Subject: Re: Are foreign key's automatically set as indicies?