Re: Restoring dtabase problem - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Restoring dtabase problem
Date
Msg-id 44D3AD0D.1040200@commandprompt.com
Whole thread Raw
In response to Re: Restoring dtabase problem  ("Benjamin Krajmalnik" <kraj@illumen.com>)
List pgsql-admin
Benjamin Krajmalnik wrote:
> The problem is that I do not which rows have the problem.
> Out of a few thousand rows, there are only about 15 rows with the
> problem.
> I was wondering if there is some validation which I can run as a script
> against the table so it wil delete it.
>
> How much faster is the copy method as opposed to the insert?

Exponential.

Joshua D. Drake


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



pgsql-admin by date:

Previous
From: "Abu Mushayeed"
Date:
Subject: UTF8 question
Next
From: "Rodolfo Borges"
Date:
Subject: Re: installing on user account