Re: [admin] index in pk - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: [admin] index in pk
Date
Msg-id 20040407141946.N75206@megazone.bigpanda.com
Whole thread Raw
In response to [admin] index in pk  ("Jaime Casanova" <el_vigia_ec@hotmail.com>)
List 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.


pgsql-admin by date:

Previous
From: "Jaime Casanova"
Date:
Subject: [admin] index in pk
Next
From: "Jaime Casanova"
Date:
Subject: binary fields