Thanks it worked when I changed the command '/copy' to '\copy' -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jasen Betts Sent: Tuesday, June 09, 2009 6:03 PM To: [email protected] Subject: Re: [SQL] backup
On 2009-06-09, Jyoti Seth <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
