Re: restore multiple tables postgres

Thanks for guidance. If you could share the file, I appreciate it

Regards

On Wed, Apr 14, 2010 at 11:27 AM, Rob Richardson <Rob(dot)Richardson(at)rad-con(dot)com
> wrote:

> I often have to create test copies of a production database. The
> database has several large tables that contain historical data that is not
> needed for our system to run, and just wastes time doing backups and
> restores. I created two batch files, one for backing up and the other for
> restoring. The backup file begins with a command to backup the scheme of
> the database, and then there is a series of commands to backup the tables I
> need, once command per table. The restore file works the same way. I think
> a similar idea would help you. You could trim the batch files (or at least
> the restore batch file) to give you only the tables you need.
>
> If you want, I'd be happy to E-mail you the batch files.
>
> RobR
>
>