pg_dump with select output

On 16/02/2011 09:54, Adarsh Sharma wrote:

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.

You can't do this in pg_dump. pg_dump can backup:

- the entire database
- a schema, using -s
- a table, using -t

...but not a subset of rows from a table. Maybe you want the COPY command?

http://www.postgresql.org/docs/9.0/static/sql-copy.html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 02/16/2011 11:54 AM, Adarsh Sharma wrote:

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.

Not through pgdump, but you can do it with psql like such
psql -h 192.168.1.106 -d bicrawler -o /root/Desktop/internal_url.sql -P
format=unaligned -P fieldsep="|,|" -t -U postgres -c "select * from
internalurl where internalurl_id between 1 and 30 "

Note that you have to have postgres (or the user you are using)
authenticated by trust or it will ask for a password. You can't put the
password on the command line, though you can use a .pgpass file.