Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d9ANQ-0004pT-QE for pgsql-admin@arkaria.postgresql.org; Fri, 12 May 2017 13:13:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d9ANQ-00044n-Cu for pgsql-admin@arkaria.postgresql.org; Fri, 12 May 2017 13:13:00 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d9ANO-00042e-O1; Fri, 12 May 2017 13:12:59 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d9ANL-0003Sn-7h; Fri, 12 May 2017 13:12:57 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id C668420B88; Fri, 12 May 2017 09:12:53 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute6.internal (MEProxy); Fri, 12 May 2017 09:12:53 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=fm1; bh=Be5eXVlh2P+mg1kwhI cEt+VfTfcS+mHU+Du4Uu87yJM=; b=tfvIZY3LB+ullO/wx3osIPRbSZTqSxWGOU 2DUm6PzXcweZQLFlqMUC/89hKogudj6V2PhsKCjzH6h3zk6xU10LV6SmCEqBO0jX 9sXdn0M4k+z+lDdpB2+7PWlzlv5vYbkBmINJY2SXTi4CT8tClRP3VN56YCm0b4oW L0gzNwamPoJr0gHIRxpI/W8BrbEIFOKMDagZKHK4zoemHUaqI9AaxJH3ztACQ83X w5JCs6+jR/K7DrgJvkDYl+WHPaTKG2Ziua4qS1KfTSrEBRP7bD89i7FheSgGyEW1 Cf9PE0u78fRzD0NbZz+q93eyKypLB2KEnslyOKj51JvMPbd8knvQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= fm1; bh=Be5eXVlh2P+mg1kwhIcEt+VfTfcS+mHU+Du4Uu87yJM=; b=ISCfMUO7 5Nhml0enB6Tf0JcXXC/O+dInsm3eEZrvh3XMYu+zDDeroQ8LHwhd8H9XCOcJ6Sje IgoRq4+QjWoLcRzbLfmbf63jJZCOR93UcnSYA/oj67guiLLhjk21hnr8rIiLRTI7 UJSIXiiOlGr4VKm4sL64TtwTrg2RTZTGZiWTH6yKXBBFrcDqaGJOcO+f/2msVu4P Zwc16N/UAszSzBkevJSaiMcoOKZqodFWcE35X3/5dhg/p7DL3WlpstMtmucGXvsW 1s2efzRaX5E1sXDYhAgwzChbyhIS2TzaI+gTlGX6NPZqgza1Mnc1U63mBNmcXSyF KHReVk7DSKTOpg== X-ME-Sender: X-Sasl-enc: AhmAdyxYOLnmP3lwulpr84Uax79Q7dWBKRHL8we3dbqS 1494594773 Received: from [192.168.1.2] (97-126-85-89.tukw.qwest.net [97.126.85.89]) by mail.messagingengine.com (Postfix) with ESMTPA id 3F7747E9F8; Fri, 12 May 2017 09:12:53 -0400 (EDT) Subject: Re: [SQL] exporting query result To: =?UTF-8?Q?G=c3=bcnce_Kaya?= , pgsql-admin@postgresql.org, pgsql-sql@postgresql.org References: From: Adrian Klaver Message-ID: <4498cd4b-95b7-c4f5-add4-b6555267296a@aklaver.com> Date: Fri, 12 May 2017 06:12:52 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.1.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 05/12/2017 02:14 AM, Günce Kaya wrote: > Good morning all, > > I use COPY to exporting query result but I'm curious If there is any way > to export query result to a CSV file's different spreadsheets through > Pgadmin or server? You can export to CSV using COPY. For pgAdmin see: https://www.pgadmin.org/docs/pgadmin4/1.x/import_export_data.html?highlight=csv If this is not what you want then you will need to be more specific about what you are trying to achieve. > > Regards > > -- > Gunce Kaya > -- Adrian Klaver adrian.klaver@aklaver.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin