Postgres Pro
Downloads
Home   >   mailing lists

Re: Question on indexes - Mailing list pgsql-general

From vishal saberwal
Subject Re: Question on indexes
Date
Msg-id 3e74dc250512190829o512abb49g7f5cb3b73841b64f@mail.gmail.com
Whole thread Raw
In response to Question on indexes  (Emil Rachovsky <zsevgymko@yahoo.com>)
List pgsql-general
Tree view 
CREATE INDEX code_idx ON films(code) TABLESPACE indexspace;
http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html

vish

On 12/19/05, Emil Rachovsky <zsevgymko@yahoo.com> wrote:

Hi,
Can anyone show me a simple way of creating an index
in PostGre like that:
create index indName on someTable(someIntColumn DESC)
?

Thanks In Advance,
Emil

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

pgsql-general by date:

Previous
From: vishal saberwal
Date:
Subject: Re: libpq++ installation error
Next
From: Alvaro Herrera
Date:
Subject: Re: [SQL] Question on indexes