Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group