Re: merge 2 dumps - Mailing list pgsql-general

From Alan Hodgson
Subject Re: merge 2 dumps
Date
Msg-id 200811120806.54482@hal.medialogik.com
Whole thread Raw
In response to Re: merge 2 dumps  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
List pgsql-general
On Tuesday 11 November 2008, Joao Ferreira gmail
<joao.miguel.c.ferreira@gmail.com> wrote:
> could I just get the "COPY TO" sections from the files and load them one
> after the other ?
>
> I never tried this before...

You might have drop foreign keys before doing so and recreate them after -
the dumps aren't careful to maintain ordering.

--
Alan

pgsql-general by date:

Previous
From: paulo matadr
Date:
Subject: MAX_CONNECTIONS ??
Next
From: Tom Lane
Date:
Subject: Re: sequence not restarting in a for loop (actually semi-random numbers)