Re: [admin] index in pk

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Jaime Casanova <el_vigia_ec(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [admin] index in pk
Date: 2004-04-07 21:21:54
Message-ID: 20040407141946.N75206@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 7 Apr 2004, Jaime Casanova wrote:

> hi all, there is a way to use my own index with pk constraint instead of the
> implicitly created one?
> why? just because i don't like the name, maybe can i change the generated
> name?

You should be able use the full version with the constraint naming clause:
CONSTRAINT <name> PRIMARY KEY
to make <name> the name of the index.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Bakken 2004-04-07 21:36:51 Re: Out of space
Previous Message Jaime Casanova 2004-04-07 21:11:20 [admin] index in pk