pg_dump with select output

Поиск
Список
Период
Сортировка
От Adarsh Sharma
Тема pg_dump with select output
Дата
Msg-id 4D5B9EE5.3080900@orkash.com
обсуждение исходный текст
Ответы Re: pg_dump with select output  (Raymond O'Donnell <rod@iol.ie>)
Re: pg_dump with select output  (Sim Zacks <sim@compulab.co.il>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alessandro Candini
Дата:
Сообщение: Re: Multithreaded query onto 4 postgresql instances
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: pg_dump with select output