Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id CB3E6635AB9
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  9 Jun 2009 09:35:22 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 73066-03-7 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  9 Jun 2009 09:35:21 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from titania.wxnz.net (titania.wxnz.net [58.28.4.13])
	by mail.postgresql.org (Postfix) with ESMTP id 2D17163596C
	for <pgsql-sql@postgresql.org>; Tue,  9 Jun 2009 09:35:19 -0300 (ADT)
Received: from gonzo (ip-118-90-143-186.xdsl.xnet.co.nz [118.90.143.186])
	by titania.wxnz.net (Postfix) with ESMTP id E3E791DB824C
	for <pgsql-sql@postgresql.org>; Wed, 10 Jun 2009 00:35:15 +1200 (NZST)
Received: from news by gonzo with local (Exim 4.69)
	(envelope-from <news@reversiblemaps.ath.cx>) id 1ME0Vs-0003Bj-V1
	for pgsql-sql@postgresql.org; Wed, 10 Jun 2009 00:33:12 +1200
To: pgsql-sql@postgresql.org
Path: not-for-mail
From: Jasen Betts <jasen@xnet.co.nz>
Newsgroups: gmane.comp.db.postgresql.sql
Subject: Re: backup
Date: 9 Jun 2009 12:33:12 GMT
Organization: Dis (not Dat) Organisation
Lines: 21
Message-ID: <h0lkq8$90o$7@reversiblemaps.ath.cx>
References: <003b01c9e8e8$29f09860$7dd1c920$@com>
NNTP-Posting-Host: localhost
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: reversiblemaps.ath.cx 1244550792 9240 127.0.0.1 (9 Jun 2009 12:33:12
	GMT)
X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a
	+M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;
	(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6
	{T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;
	8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent: slrn/pre1.0.0-2 (Linux)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200906/39
X-Sequence-Number: 32644

On 2009-06-09, Jyoti Seth <jyotiseth2001@gmail.com> wrote:
> This is a multipart message in MIME format.
>
> ------=_NextPart_000_003C_01C9E916.43A8D460
> Content-Type: text/plain;
> 	charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hi all,
>
>  
>
> Can we take backup of specific data of a table (using where clause)?

in psql:

/copy (select * from table WHERE condition ) to 'FILENAME'

requires postgres version >= 8.2 IIRC.

you can use any query.