Read what the command CLUSTER does. Definately not what you think.
You create clustered indeces as you would any index:
create index lala_idx on lala (col1,col2,...);
cheers,
thalis
On Fri, 15 Jun 2001, Dariusz Pietrzak wrote:
> Hello,
> how can I create clustered index on given table?
> When I try "cluster indexname on tablename" it drops and recreates this
> table, effectively dropping all constraints.
> Can I create clustered index without loosing my foreign key etc
> constraints?
>
> --
> Dariusz Pietrzak
> Certified Nobody
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>