Re: Extracting data into .csv format

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Ferrell, Denise D CTR NSWCDD, H11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Extracting data into .csv format
Date: 2016-02-17 16:55:25
Message-ID: CAKFQuwYWWmLR4h1E2_BsTwm5POQC8J3gz-4VcJ6iyZGhGnAAYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Feb 17, 2016 at 9:49 AM, Ferrell, Denise D CTR NSWCDD, H11 <
denise(dot)ferrell(dot)ctr(at)navy(dot)mil> 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?
>

In the documentation lookup the psql "\copy" meta-command along with the
SQL COPY command.​

David J.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ziggy Skalski 2016-02-17 17:00:00 Re: Extracting data into .csv format
Previous Message Stephen Tahmosh 2016-02-17 16:55:00 Re: Extracting data into .csv format