DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=from:to:references:in-reply-to:subject:date:message-id:mime-version
	:content-type:content-transfer-encoding:x-mailer:thread-index
	:content-language:x-cr-hashedpuzzle:x-cr-puzzleid;
	b=gEKadNK2NiBVdrEzHX0tu0SzwWXMpjh8cflpqQ/79kMzY/h2/J/YgO0+OCPlfWoh5w
	6iIFm05XbgE6CEWsKPSjIUkSgbvtzAhTabY0Uj+qE38kBn+6VkP/oifpYIggIskkpy1G
	Z/0GkzLvvVXjtfZrBQxe+kGEAY/EoMaLRjc1A=
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: "'Jasen Betts'" <jasen@xnet.co.nz>,
	<pgsql-sql@postgresql.org>
References: <003b01c9e8e8$29f09860$7dd1c920$@com>
	<h0lkq8$90o$7@reversiblemaps.ath.cx>
In-Reply-To: <h0lkq8$90o$7@reversiblemaps.ath.cx>
Subject: Re: backup
Date: Wed, 10 Jun 2009 10:38:30 +0530
Message-ID: <001b01c9e989$821d7610$86586230$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: Acno/t1diVmAf4ABSsy9QJzOQPP61wAimoqQ
Content-Language: en-us

I tried using /copy command. It is not giving any error but also not
creating any file.

Thanks
Jyoti

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Jasen Betts
Sent: Tuesday, June 09, 2009 6:03 PM
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] backup

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.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql