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 26DDFD6E67 for ; Thu, 25 Aug 2005 19:25:52 -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 12656-08 for ; Thu, 25 Aug 2005 22:25:51 +0000 (GMT) Received: from dfrobd01.vailsys.com (chrobd01.vailsys.com [63.210.102.138]) by svr1.postgresql.org (Postfix) with ESMTP id D4562D6D8D for ; Thu, 25 Aug 2005 19:25:50 -0300 (ADT) Received: from dfsfbd06.vail (dfsfbd06.vail [192.168.129.190]) by dfrobd01.vailsys.com (Postfix) with ESMTP id AF028FF2F for ; Thu, 25 Aug 2005 17:25:53 -0500 (CDT) Received: from [192.168.129.86] (dfwddurham.vail [192.168.129.86]) by dfsfbd06.vail (Postfix) with ESMTP id C71EB5925 for ; Thu, 25 Aug 2005 17:24:53 -0500 (CDT) Message-ID: <430E4536.3030203@vailsys.com> Date: Thu, 25 Aug 2005 17:24:54 -0500 From: David Durham User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050404) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-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-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200508/326 X-Sequence-Number: 18645 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