Re: Restoring a table with a different name

From: "Jim Wilson" <jimw(at)kelcomaine(dot)com>
To: "Mike Nolan" <nolan(at)gw(dot)tssi(dot)com>, "pgsql general list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restoring a table with a different name
Date: 2004-02-28 00:54:09
Message-ID: twig.1077929649.39531@kelcomaine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Nolan said:

> I have a 600K row table on my production system (running 7.3.3)
> that I dump and load on my development system (7.4.1) every night using
> cron jobs.
>
> I would like to be able to restore the table under a different table name
> without first having to play games with the development copy of the table.
>
> If I edit the dump file with 'sed' to change the table name, I get
> 'invalid command \N' errors trying to reload it.

What sed syntax are you using?

Best,

Jim Wilson

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-02-28 01:11:22 Re: Regarding BITs vs. INTs
Previous Message Bill Moran 2004-02-28 00:47:53 Regarding BITs vs. INTs