[GENERAL] restore multiple tables postgres

2010-04-14 Thread akp geek
Dear all - Can you please help me with this? Is there a way to restore multiples ( more than one table ) using a single command from a whole database dump that was created using pg_dump regards

Re: [GENERAL] restore multiple tables postgres

2010-04-14 Thread Scott Mead
On Wed, Apr 14, 2010 at 10:56 AM, akp geek akpg...@gmail.com wrote: Dear all - Can you please help me with this? Is there a way to restore multiples ( more than one table ) using a single command from a whole database dump that was created using pg_dump Depends on exactly how you

Re: [GENERAL] restore multiple tables postgres

2010-04-14 Thread raghavendra t
Hi Hope this will help you out. Its has bothe pg_dump and pg_restore, with -t option http://www.postgresql.org/docs/8.4/static/app-pgrestore.html Regards Raghavendra On Wed, Apr 14, 2010 at 8:33 PM, Scott Mead scott.li...@enterprisedb.comwrote: On Wed, Apr 14, 2010 at 10:56 AM, akp geek

Re: [GENERAL] restore multiple tables postgres

2010-04-14 Thread Scott Mead
On Wed, Apr 14, 2010 at 11:03 AM, Scott Mead scott.li...@enterprisedb.comwrote: On Wed, Apr 14, 2010 at 10:56 AM, akp geek akpg...@gmail.com wrote: Dear all - Can you please help me with this? Is there a way to restore multiples ( more than one table ) using a single command from a

Re: [GENERAL] restore multiple tables postgres

2010-04-14 Thread akp geek
Thanks a lot. On Wed, Apr 14, 2010 at 11:15 AM, Scott Mead scott.li...@enterprisedb.comwrote: On Wed, Apr 14, 2010 at 11:03 AM, Scott Mead scott.li...@enterprisedb.com wrote: On Wed, Apr 14, 2010 at 10:56 AM, akp geek akpg...@gmail.com wrote: Dear all - Can you please help me

Re: [GENERAL] restore multiple tables postgres

2010-04-14 Thread Rob Richardson
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.

Re: [GENERAL] restore multiple tables postgres

2010-04-14 Thread akp geek
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.richard...@rad-con.com wrote: I often have to create test copies of a production database. The database has several large tables that contain historical data that

Re: [GENERAL] restore multiple tables postgres

2010-04-14 Thread Ivan Sergio Borgonovo
On Wed, 14 Apr 2010 10:56:36 -0400 akp geek akpg...@gmail.com wrote: Dear all - Can you please help me with this? Is there a way to restore multiples ( more than one table ) using a single command from a whole database dump that was created using pg_dump Something along the line