Abdul Rahman wrote: > > In Oracle, the index is automatically created during the creation of > Primary Key.
The same is true in PostgreSQL. For example, here's a message from a recent job I ran that created a temp table with SELECT ... INTO and added a primary key to it: psql:import_checks.sql:79: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "check_weeks_pkey" for table "check_weeks" Can you give an example of what you are talking about? > But in PostgreSQL either index is implicitly created Is "implicitly" in some way intended to mean something distinct to "automatically"? > I don't find any index against Primary > Key and have to create index on this key. AFAIK you CAN NOT have a PRIMARY KEY in PostgreSQL without an associated unique index. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
