pg_dump with select output

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump with select output
Date: 2011-02-16 09:54:45
Message-ID: 4D5B9EE5.3080900@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

I am using pg_dump in Postgresql database very often and read several
parameters of it.
But today i want to back up that part of table which satisfies satisfies
certain condition ( select command ).

In mysql , this is achieved as below :

mysqldump -h192.168.1.106 -uroot -porkash -q -w"internalurl_id between 1
and 30" bicrawler internalurl > /root/Desktop/internal_url.sql

-w option is used for executing select command .

But don't know how this is achieved through pg_dump command.

Please help.

Thanks & best Regards,

Adarsh Sharma

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-02-16 10:02:26 Re: pg_dump with select output
Previous Message Alessandro Candini 2011-02-16 08:54:59 Re: Multithreaded query onto 4 postgresql instances