On Wed, 14 Apr 2010 10:56:36 -0400
akp geek 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 of:
http://www
Thanks for guidance. If you could share the file, I appreciate it
Regards
On Wed, Apr 14, 2010 at 11:27 AM, Rob Richardson 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 s
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. T
Thanks a lot.
On Wed, Apr 14, 2010 at 11:15 AM, Scott Mead
wrote:
>
> On Wed, Apr 14, 2010 at 11:03 AM, Scott Mead > wrote:
>
>>
>> On Wed, Apr 14, 2010 at 10:56 AM, akp geek wrote:
>>
>>> Dear all -
>>>
>>> Can you please help me with this? Is there a way to restore
>>> multiples ( mor
On Wed, Apr 14, 2010 at 11:03 AM, Scott Mead
wrote:
>
> On Wed, Apr 14, 2010 at 10:56 AM, akp geek 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 cr
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 wrote:
>
> On Wed, Apr 14, 2010 at 10:56 AM, akp geek wrote:
>
>> Dear all -
>>
>>
On Wed, Apr 14, 2010 at 10:56 AM, akp geek 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 took the pg_
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
