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