Re: Question about \copy

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: johnw822003(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about \copy
Date: 2009-03-11 17:37:07
Message-ID: dcc563d10903111037m58aebc58h22ae3c21fdc2ceb8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 11, 2009 at 11:21 AM, John Wang <johnw822003(at)yahoo(dot)com> wrote:
>
>
> I have a table, for example, Product. It's index is Product_index.
>
> If I use \copy to load data into the table:
>
> \copy Product from data.txt
>
> Will the index, Product_index, also be updated with the new data during "copy"?

Yep.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message F. Jovan Jester 2009-03-11 17:50:16 Re: Question about \copy
Previous Message Scott Marlowe 2009-03-11 17:36:27 Re: Server Shutting Down