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;
	b=P9YYe5251ERuyYmfdfjMvCnAEODCPzybk+/ZPtjqDeFM9dA0KwYAQNcDR3XEpc2tZY
	0jSNn23i5nx8rlFXPPQk3dMQCP6Do0eR3rI8N6LuhzEcEcZo9l3lZXknEpyE+rimVJuj
	/VpXQC85fSeJHpRtbbyTyaLF+MNLkd/FXHJjU=
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 11:16:35 +0530
Message-ID: <001c01c9e98e$d4421c20$7cc65460$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: Acno/t1diVmAf4ABSsy9QJzOQPP61wAj4F9A
Content-Language: en-us

Thanks it worked when I changed the command '/copy' to '\copy'

-----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