Postgres Pro
Downloads
Home   >   mailing lists

Re: CLUSTER equivalent - Mailing list pgsql-general

From Neil Conway
Subject Re: CLUSTER equivalent
Date
Msg-id 4329DAF6.405@samurai.com
Whole thread Raw
In response to CLUSTER equivalent  (Kevin Murphy <murphy@genome.chop.edu>)
Responses Re: CLUSTER equivalent
List pgsql-general
Tree view 
Kevin Murphy wrote:
> I just wanted to confirm that the COPY command always stores data in the
> table in the order in which it appears in the import file.

This is not the case -- depending on the content of the FSM, the newly
added rows might be distributed throughout the table.

-Neil

pgsql-general by date:

Previous
From: CSN
Date:
Subject: character varying == text?
Next
From: Neil Conway
Date:
Subject: Re: Questions about "varchar" NOT NULL default = char(1)