Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group