Re: Restoring a table with a different name - Mailing list pgsql-general

From Jim Wilson
Subject Re: Restoring a table with a different name
Date
Msg-id twig.1077929649.39531@kelcomaine.com
Whole thread Raw
In response to Restoring a table with a different name  (Mike Nolan <nolan@gw.tssi.com>)
Responses Re: Restoring a table with a different name
List 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



pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Regarding BITs vs. INTs
Next
From: Stephan Szabo
Date:
Subject: Re: Regarding BITs vs. INTs