Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4D6509FA249 for ; Wed, 27 Dec 2006 08:03:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 57672-04 for ; Wed, 27 Dec 2006 08:03:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ricor.server.int (unknown [81.73.241.10]) by postgresql.org (Postfix) with SMTP id AE1F99F9F46 for ; Wed, 27 Dec 2006 08:03:08 -0400 (AST) Received: (qmail 4070 invoked by uid 1019); 27 Dec 2006 11:58:41 -0000 Received: from scotty@linuxtime.it by ricor by uid 1012 with qmail-scanner-1.22st (clamdscan: 0.70. Clear:RC:1(127.0.0.1):. Processed in 0.047978 secs); 27 Dec 2006 11:58:41 -0000 Received: from ricor.server.int (HELO mypc.ricordatasystem.info) (127.0.0.1) by 0 with SMTP; 27 Dec 2006 11:58:41 -0000 Date: Wed, 27 Dec 2006 14:05:30 +0100 From: Enrico To: pgsql-admin@postgresql.org Subject: Dump and Query Message-Id: <20061227140530.094fc4d3.scotty@linuxtime.it> X-Mailer: Sylpheed 2.3.0rc (GTK+ 2.6.4; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/332 X-Sequence-Number: 24124 Is there any way to make a dump from a query? For example if my query is: select field1,field2 from table Does it exist a shell command like pg_dump --QUERY myquery -f myfile? Have a nice day Enrico -- If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already is !!!! scotty@linuxtime.it - Skype:sscotty71 http://www.linuxtime.it/enricopirozzi