Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 51D326350C2 for ; Tue, 9 Jun 2009 07:02:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 52149-02 for ; Tue, 9 Jun 2009 07:02:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og121.obsmtp.com (exprod7og121.obsmtp.com [64.18.2.20]) by mail.postgresql.org (Postfix) with SMTP id 4085B6350E8 for ; Tue, 9 Jun 2009 07:02:18 -0300 (ADT) Received: from source ([209.85.198.251]) by exprod7ob121.postini.com ([64.18.6.12]) with SMTP ID DSNKSi4zKKBkYj/XTBNFZcPdyC728a3aZR9I@postini.com; Tue, 09 Jun 2009 03:02:17 PDT Received: by rv-out-0708.google.com with SMTP id l33so1284608rvb.30 for ; Tue, 09 Jun 2009 03:02:16 -0700 (PDT) Received: by 10.141.3.10 with SMTP id f10mr6450680rvi.120.1244541736321; Tue, 09 Jun 2009 03:02:16 -0700 (PDT) Received: from ?192.168.23.130? ([121.241.184.130]) by mx.google.com with ESMTPS id g14sm15229295rvb.52.2009.06.09.03.02.13 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 09 Jun 2009 03:02:15 -0700 (PDT) Message-ID: <4A2E3353.6060405@enterprisedb.com> Date: Tue, 09 Jun 2009 15:32:59 +0530 From: Ashish Karalkar User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: Jyoti Seth CC: pgsql-sql@postgresql.org Subject: Re: backup References: <003b01c9e8e8$29f09860$7dd1c920$@com> In-Reply-To: <003b01c9e8e8$29f09860$7dd1c920$@com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200906/38 X-Sequence-Number: 32643 Jyoti Seth wrote: > > Hi all, > > > > Can we take backup of specific data of a table (using where clause)? > > > > Thanks, > > Jyoti > > > Try Selective COPY With Regards Ashish Karalkar EnterpriseDB