Re: copy command and indexes - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: copy command and indexes
Date
Msg-id 200006141442.KAA11732@candle.pha.pa.us
Whole thread Raw
In response to Re: copy command and indexes  ("Anthony E. Greene" <agreene@pobox.com>)
List pgsql-admin
> At 14:53 2000-06-13 -0500, Tim White wrote:
> >When using the copy command to bulk load data, will it update the indexes,
> >or do you have to explicitly drop and recreate the indexes?
>
> Only data tables are loaded. Indexes and other data must be recreated.

Woh.  COPY updates all indexes.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: Michael Ansley
Date:
Subject: RE: view performance
Next
From: "John Daniels"
Date:
Subject: Re: FreeBSD PostgreSQL7 port and v7.0.2