Re: copy command and indexes

From: "Anthony E(dot) Greene" <agreene(at)pobox(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: copy command and indexes
Date: 2000-06-14 11:59:29
Message-ID: 3.0.5.32.20000614135929.008104c0@fmol.5sigcmd.army.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Loïc TREGOUËT 2000-06-14 12:26:11 view performance
Previous Message Peter Eisentraut 2000-06-14 11:19:20 Re: Money Data type