Re: [SQL] OID & indexes. - Mailing list pgsql-sql

From José Soares
Subject Re: [SQL] OID & indexes.
Date
Msg-id 37E8CBDE.B87F1653@sferacarta.com
Whole thread Raw
In response to OID & indexes.  (raptor <raptor@unacs.bg>)
List pgsql-sql

raptor ha scritto:

> hi,
>
> Is the OID fileld indexed and if not can I create index on it.
>

The OID field is not indexed by default but you can create an index on
it as:
create index idx_name on  table_name (oid);

José




pgsql-sql by date:

Previous
From: José Soares
Date:
Subject: Re: [SQL] Book on SQL
Next
From: Stuart Rison
Date:
Subject: [GENERAL] UPDATE feature or bug?