Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j9kpg-0001ET-AO for pgsql-admin@arkaria.postgresql.org; Thu, 05 Mar 2020 07:22:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j9kpe-0001AU-Sz for pgsql-admin@arkaria.postgresql.org; Thu, 05 Mar 2020 07:22:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j9kpe-0001AN-H5 for pgsql-admin@lists.postgresql.org; Thu, 05 Mar 2020 07:22:10 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1j9kpc-0005dy-9z for pgsql-admin@lists.postgresql.org; Thu, 05 Mar 2020 07:22:10 +0000 Received: by mail-lj1-x22d.google.com with SMTP id w1so4874292ljh.5 for ; Wed, 04 Mar 2020 23:22:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=29/ACIPB4Fc76sEXnXXCP1HhAzvAUi/nAA5lMPy3Sss=; b=JQB75R3Y2xIowl2jfwihsl9jyfoaR/nRwokGS2051Uh/5GSTzrJKXktHH9wS2hU3i+ hOnUauRHbiB4kECwRXfE4IsGHLlrSzWC9u4tXZrfRiPTHmQBtlSegpdmMV1R/hT8s1T2 K7/UdQcbd0/O5Sf4tqiFLNhsffud/lSj1B/Pwbr3mlRqt+vKCRZoJPexIAozNAt86l8L rx8QAOct3PXv8qFAk4ReHFP6XIQ39TKTFNmcw4MmXEZq0gLo3SGToW1s2idPLlkn2pGV 6CHthWcBUNddHVJliCmES1Gv/U5prA8OS1RIW7C0wWrVQftzikZ8WYl/0rlLFo8+mxxn oj4w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=29/ACIPB4Fc76sEXnXXCP1HhAzvAUi/nAA5lMPy3Sss=; b=er2NzbmcMaKaNtSZSLI04KO1PpPvM4fO7ZI/Ifp2HO1lH/luF8QiBdoqlHHj1wG9Dw U/eaDwACfjiznLeE58M760IGVO2m8K0DSXDTdNUXZ8ulkuCBjxJCG0E5gX7hGuX/dw2J BK0OOm7RGzSnYyrVhyJRzodsUdqjCBndlMI9oZ8O5hrFSEQ3Tdk9UJqpsV80BlLq2Wwd utI/evgLD8/Jei/vO3rTzTumwptajz+wU+FmQqVNkNtMY9IMw+m175Jl/4o94VeD6eLz lC0+RUUhNsWNYr7L1mrqSJL4bcWMcxFL5prW0ECrol0ETzLZVOCV9WY/3J0yUIOXE8v/ 7dFg== X-Gm-Message-State: ANhLgQ2dB539Vd5dqjREq0+1Q5IcGFrL866GZD2YMDFQ8YeMofHE3VAb MbgfINgKTnaaGfUmnyN6P9Z8YNJYz/U= X-Google-Smtp-Source: ADFU+vsL1id+bYz34QZCZYO6As3gc15nY2fGEzkUDP7JNcX8PphzhT638In82q0ECg5koRRs5GctwA== X-Received: by 2002:a2e:b521:: with SMTP id z1mr4510885ljm.19.1583392925806; Wed, 04 Mar 2020 23:22:05 -0800 (PST) Received: from [192.168.1.8] (93-161-90-27-static.dk.customer.tdc.net. [93.161.90.27]) by smtp.gmail.com with ESMTPSA id z9sm14467451lfq.48.2020.03.04.23.22.04 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 04 Mar 2020 23:22:05 -0800 (PST) Subject: Re: Suggestion to reduce COPY command output to csv file To: pgsql-admin@lists.postgresql.org References: From: Bo Victor Thomsen Message-ID: <334c89b7-8643-2642-4fe9-8f8ca4905526@gmail.com> Date: Thu, 5 Mar 2020 08:22:08 +0100 User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:68.0) Gecko/20100101 Thunderbird/68.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------9D97DEDDCA71E311CB27CF91" Content-Language: en-GB List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------9D97DEDDCA71E311CB27CF91 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit You can use this alternative: /\copy (SELECT col1, col2, col3... from cities) TO '/var/lib/pgsql/cities.csv' (DELIMITER ',', FORMAT 'csv', HEADER)/ The list /col1, col2, col3.../ should only contain names on*necessary* columns and not under any circumstances  the geometry column -- Med venlig hilsen / Kind regards Bo Victor Thomsen Den 04-03-2020 kl. 19:38 skrev postggen2020 s: > \copy cities TO '/var/lib/pgsql/cities.csv' (DELIMITER ',', FORMAT > 'csv', HEADER) --------------9D97DEDDCA71E311CB27CF91 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

You can use this alternative:

\copy (SELECT col1, col2, col3... from cities) TO '/var/lib/pgsql/cities.csv' (DELIMITER ',', FORMAT 'csv', HEADER)

The list col1, col2, col3... should only contain names on necessary columns and not under any circumstances  the geometry column 


-- 
Med venlig hilsen / Kind regards

Bo Victor Thomsen



Den 04-03-2020 kl. 19:38 skrev postggen2020 s:
\copy cities TO '/var/lib/pgsql/cities.csv' (DELIMITER ',', FORMAT 'csv', HEADER)

  


--------------9D97DEDDCA71E311CB27CF91--