It should be \copy . This is a psql command; if you have direct access to database host machine, you might want to use the SQL command COPY for it's performance.
http://www.postgresql.org/docs/8.3/interactive/app-psql.html http://www.postgresql.org/docs/8.3/interactive/sql-copy.html Best regards, On Wed, Jun 10, 2009 at 10:38 AM, Jyoti Seth <jyotiseth2...@gmail.com>wrote: > 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 > -- Lets call it Postgres EnterpriseDB http://www.enterprisedb.com gurjeet[.sin...@enterprisedb.com singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com Mail sent from my BlackLaptop device
