I tried using /copy command. It is not giving any error but also not creating any file.
Thanks Jyoti -----Original Message----- From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@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 <jyotiseth2...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
