X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 93BF7D78A3 for ; Thu, 25 Aug 2005 20:30:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26384-09 for ; Thu, 25 Aug 2005 23:30:06 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id 1839FD78B4 for ; Thu, 25 Aug 2005 20:30:06 -0300 (ADT) Received: from localhost (av.hub.org [200.46.204.144]) by hub.org (Postfix) with ESMTP id BC7AB64BC5B for ; Thu, 25 Aug 2005 20:30:09 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25149-09 for ; Thu, 25 Aug 2005 23:30:04 +0000 (GMT) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id E586464BC4D for ; Thu, 25 Aug 2005 20:30:07 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id BF8593CCB0; Thu, 25 Aug 2005 20:30:09 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id BED603CC80 for ; Thu, 25 Aug 2005 20:30:09 -0300 (ADT) X-Return-Path: X-Received: from localhost ([unix socket]) by ganymede.hub.org (Cyrus v2.2.12) with LMTPA; Thu, 25 Aug 2005 19:20:32 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 935523D3CC for ; Thu, 25 Aug 2005 19:20:26 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5.2) for scrappy@localhost (single-drop); Thu, 25 Aug 2005 19:20:26 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.12) with LMTPA; Thu, 25 Aug 2005 19:16:47 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 14F69D77D1 for ; Thu, 25 Aug 2005 19:16:47 -0300 (ADT) X-Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12054-06 for ; Thu, 25 Aug 2005 22:16:43 +0000 (GMT) X-Received: from chrobd01.vailsys.com (chrobd01.vailsys.com [63.210.102.138]) by svr1.postgresql.org (Postfix) with ESMTP id 5FF07D7712 for ; Thu, 25 Aug 2005 19:16:42 -0300 (ADT) X-Received: from dfsfbd06.vail (dfsfbd06.vail [192.168.129.190]) by chrobd01.vailsys.com (Postfix) with ESMTP id CC4EC4992 for ; Thu, 25 Aug 2005 17:16:44 -0500 (CDT) X-Received: from [192.168.129.86] (dfwddurham.vail [192.168.129.86]) by dfsfbd06.vail (Postfix) with ESMTP id 86F4E5640 for ; Thu, 25 Aug 2005 17:16:29 -0500 (CDT) Message-ID: <430E433E.5000405@vailsys.com> Date: Thu, 25 Aug 2005 17:16:30 -0500 From: David Durham User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050404) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pg-admin@postgresql.org Subject: dumping query results to a csv Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-DCC: : X-Spam-Pyzor: ReSent-Date: Thu, 25 Aug 2005 20:30:05 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-admin@postgresql.org ReSent-Subject: dumping query results to a csv ReSent-Message-ID: <20050825203005.H1044@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.946 required=5 tests=[AWL=0.896, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200508/339 X-Sequence-Number: 18658 This is kind of a pg-admin newbie question, so apologies in advance. Anyway, I'd like to issue a command that dumps the results of a query to a txt file in comma delimited format. Does PostgreSQL ship with something to do this? I searched the web, but found what appeared to be non-free solutions. Thanks, Dave