Re: [SQL] rename primary key

Le 15/01/2010 04:39, Seb a écrit : > On Fri, 15 Jan 2010 12:34:15 +0900, > Ian Barwick wrote: > [...] > On a related note: how come pgadmin3 shows "Indexes (0)" for such a > table, even though an index does exist for the primary key? Are these > indexes created in a separate table that is looked

Re: [SQL] rename primary key

On Fri, 15 Jan 2010 12:34:15 +0900, Ian Barwick wrote: [...] > Is this what you mean? [...] Exactly! Thanks. On a related note: how come pgadmin3 shows "Indexes (0)" for such a table, even though an index does exist for the primary key? Are these indexes created in a separate table that is

Re: [SQL] rename primary key

2010/1/15 Seb : > Hi, > > Is it possible to rename a primary key?  I learnt that to rename foreign > keys one has to drop it and recreate with the new name, or add a new new > and drop the old one.  What is the approach for primary keys?  Thanks. Is this what you mean? psql (8.4.2) You are now c

[SQL] rename primary key

Hi, Is it possible to rename a primary key? I learnt that to rename foreign keys one has to drop it and recreate with the new name, or add a new new and drop the old one. What is the approach for primary keys? Thanks. Cheers, -- Seb -- Sent via pgsql-sql mailing list (pgsql-sql@postgresq