Re: Are foreign key's automatically set as indicies?

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: Are foreign key's automatically set as indicies?
Дата
Msg-id 464F11FE.70205@iol.ie
обсуждение исходный текст
Ответ на Are foreign key's automatically set as indicies?  (camb <mvpaustralia@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: filippo
Дата:
Сообщение: change database encoding without corrupting data (latin9 to utf8)
Следующее
От: PFC
Дата:
Сообщение: Re: Are foreign key's automatically set as indicies?