Postgres Pro
Downloads
Home   >   mailing lists

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

From Anthony E. Greene
Subject Re: copy command and indexes
Date
Msg-id 3.0.5.32.20000614135929.008104c0@fmol.5sigcmd.army.mil
Whole thread Raw
In response to copy command and indexes  ("Tim White" <twhite@friendlyworks.com>)
Responses Re: copy command and indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Tree view 
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.

 Tony
 --
 Anthony E. Greene <agreene@pobox.com>
 PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
 Linux: The choice of a GNU Generation.

pgsql-admin by date:

Previous
From: Mario Amado Alves
Date:
Subject: Re: copy command and indexes
Next
From: Loïc TREGOUËT
Date:
Subject: view performance