Subject: Re: Extracting data into .csv format
To: pgsql-admin@postgresql.org
References: 
 <2BC18916DE4BF141AC1EFC55CE2CAE7D1B8DAE47@NAEANRFKXM01V.nadsusea.nads.navy.mil>
From: Ziggy Skalski <zskalski@afilias.info>
Message-ID: <56C4A710.6050309@afilias.info>
Date: Wed, 17 Feb 2016 12:00:00 -0500
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0)
 Gecko/20100101 Thunderbird/38.2.0
MIME-Version: 1.0
In-Reply-To: 
 <2BC18916DE4BF141AC1EFC55CE2CAE7D1B8DAE47@NAEANRFKXM01V.nadsusea.nads.navy.mil>
Content-Type: multipart/alternative;
 boundary="------------060605010108040508050304"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------060605010108040508050304
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

On 2016-02-17 11:49 AM, Ferrell, Denise D CTR NSWCDD, H11 wrote:
> Using PostgreSQL 9.3 on Linux
>
> I'm trying to extract data into a comma delimited format and not having much success...seems to act totally different from Oracle.  Does anyone have any suggestions?
>
> Thank you in advance.
> Denise
Have you tried something like i.e.:

psql -c "COPY ( QUERY ) TO STDOUT WITH CSV HEADER " > CSV_FILE.csv

Should do the trick (assuming it's basic output you're after).

Regards,

Ziggy


--------------060605010108040508050304
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 2016-02-17 11:49 AM, Ferrell, Denise
      D CTR NSWCDD, H11 wrote:<br>
    </div>
    <blockquote
cite="mid:2BC18916DE4BF141AC1EFC55CE2CAE7D1B8DAE47@NAEANRFKXM01V.nadsusea.nads.navy.mil"
      type="cite">
      <pre wrap="">Using PostgreSQL 9.3 on Linux 

I'm trying to extract data into a comma delimited format and not having much success...seems to act totally different from Oracle.  Does anyone have any suggestions?

Thank you in advance.
Denise
</pre>
    </blockquote>
    Have you tried something like i.e.:<br>
    <br>
    psql -c "COPY ( QUERY ) TO STDOUT WITH CSV HEADER " &gt;
    CSV_FILE.csv
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <br>
    <br>
    Should do the trick (assuming it's basic output you're after).<br>
    <br>
    Regards,<br>
    <br>
    Ziggy<br>
    <br>
  </body>
</html>

--------------060605010108040508050304--